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.
N9453JStarbard Donald · Crystal Bay, NVN9453NBroody George E Jr · Berwick, PAN9453VNavflight Inc · Fort Worth, TXN9453WLifetime Aviation Services LLC · Muncie, INN9454CPuglia Frank V · El Cajon, CAN9454SStoddart Bruce K · Brighton, MIN9455Sessions Richard T · Houston, TXN94553Delta State University · Cleveland, MSN9455LNollette Joseph B · Spokane, WAN9455NSchreiber Jeffrey H · Mundelein, ILN94569Chester Charter Inc · Chester, CTN9456DMajka Marc · San Carlos, CAN9456MDickey Brandon · Willow, AKN9456VSnover Darryl A · Cherryville, PAN9456WEngwis Douglas R · Rhodes, MIN94570Richmor Aviation Inc · Hudson, NYN94573Sky West Aviation Inc Trustee · Albuquerque, NMN94577Ace Aircraft Leasing Inc · Nazareth, PAN9457DN1705r Inc · Cobb, CAN9457NHermes Aviation Partners LLC · Boca Raton, FLN9457PN84dt LLC · Missoula, MTN9457WMast Henry V · Dayton, TXN94584Sale Reported · West Lafayette, INSale reportedN94585Aviation Trade Inc · Castroville, TXN94589Haverlock Aircraft LLC · Willoughby, OHN9458JTibbitts Dennis C · Woodstock, ILN9458NSwaz Aviation LLC · Mesa, AZN9459Sullivan Stanley D · South Jordan, UTN9459CFlight Trainer LLC · Wilmington, DEN9459NEngel Stephen J · Plymouth, INN9459TAdventures In The Sky Aviation LLC · Fresno, CAN945CPCivil Air Patrol · Maxwell Afb, ALN945DBHoskins Joshua C · Frisco, TXN945DPPeer Thomas A · Tullahoma, TNN945DSKnox Matthew · New Carlisle, OHN945EBFlying Z LLC · East Lansing, MIN945FGRidgeline Assets LLC · Wilmington, DEN945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN945GPrimewings Holdings LLC · Sunnyvale, CAN945GBWarbalow Peter R · Minocqua, WIN945JKSweetair Aviation · West Monroe, LAN945KMSkypros East Kansas City · Grain Valley, MON945LBAllegro Jeff · Upper Lake, CAN945MCPacific Northwest Aircraft Leasing Inc · Meridian, IDN945PDHickmott Mark T · Sunol, CAN945PLWheatley John P Jr · Thorp, WAN945SAJahawk Leasing LLC · Sugar Grove, ILN945SMFive Rivers Flight Training LLC · Livermore, CAN945TC R Transport Inc · Wilmington, DEN945TADms Aviation Services LLC · Wildwood, MO
Back to AD 81-18-04 R2