AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N92888Knudsen Wayne D · Dakota City, NEN92889Miller Andy · Marana, AZN9288BWuest Air LLC · Wilmington, DEN9288JMccormack John P · New Castle, INN9288KCoug Air LLC · Oregon City, ORN9288MHogue Marc A · Tempe, AZN9288RShane Wilson Pa · Fort Myers, FLN9288VMooney N9288v LLC · Fernandina Beach, FLN9288WThut Bruno H · Chagrin Falls, OHN92894Smith Rex H · Fort Bragg, CAN9289CSmallwood Chadwick D · Newnan, GAN9289LMainland Thomas L · Kansasville, WIN9289MUa Aero LLC · Lewes, DEN9289SThomsen Patrick J · Star Prairie, WIN9289VSteel Richard Allen · Milford, NHN9289WCoffman John H · Polo, ILN928ARGuluzza Gary W · Canyon Country, CAN928BLWingsleasing LLC · Wichita, KSN928CPCivil Air Patrol · Maxwell Afb, ALN928DSColey Thomas B · Westchester, ILN928EARegistered aircraftN928EFAon-Adharc Aircraft Leasing LLC · Sellersburg, INN928FGMustang Sally Aviation LLC · Camden, SCN928GSSmallwood Eric T · Lawrenceburg, INN928GTD Aumeries Baudouin G · Pagosa Springs, CON928HWSouthern Aircraft Consultancy Inc Trustee · Casper, WYN928LPMontana Freedom Riders LLC · Corvallis, MTN928LYLp Aviation Maintenance LLC · Bayonne, NJN928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeN928MTMountain View Cabin LLC · Southlake, TXN928NHMammoth Fuels LLC · Logan, UTN928PBoyer Brian · Gilbert, AZN928PPSwair LLC · Denver, CON928TAPray Aviation Inc · Augusta, KSN928TGNorthward Bound LLC · Anchorage, AKN928VLLa Rocca Victor J · San Antonio, TXN928WAChapman Martha P · Rogersville, TNN928WCMatthews Kyle · Dayton, OHN928WTMoxie Leasing LLC · Clarkdale, AZN928ZAFf22 LLC · Scottsdale, AZN92908C-140 Company LLC · Pensacola, FLN9290CMym Air LLC · Pattison, TXN9290DSymons George Jay Trustee · San Francisco, CAN9290JRodgers Bruce F · Quakertown, PAN9290KArrow Leaseback LLC · Danbury, CTN9290NFlight Vision 1 LLC · Lake Mary, FLN9290PSpartan Education LLC · Tulsa, OKN9290SRoss Executive Aviation Inc · Fort Smith, ARN9290TWings Flight Enterprises Inc · Danville, KYN9290UPiper Aircraft Inc · Vero Beach, FL
Back to AD 81-18-04 R2