AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N704CBLewis Stephen · Hayden, IDN704CEB2w Corporation · Winona, MNN704CFWilbur Blake G · Kent, WAN704CMCarpenter Devon W · Mountain Top, PAN704CNTm Aero Marine Inc · North Miami, FLN704CSHolloway James H · Merritt Island, FLN704CURogers Gale Allen · Jonesborough, TNN704CXAlbatross Air Inc · Beaver, WVN704CYKimbrel Michael R · Shreveport, LAN704DBAndrews University · Berrien Springs, MIN704DFMaples Andrew L · Wilmington, DEN704DGEastern Florida State College · Cocoa, FLN704DHDelaware River Flyers LLC · Dover, DEN704DJStevens Robert L · Wauseon, OHN704DMTodd R Ray · Lewisville, NCN704DSMeza Mike A · Aledo, TXN704DTWasson Tom L · Lakeport, CAN704DUWinstead Walley K · Leavenworth, KSN704DXBaskov Andrei · Irvine, CAN704DYSommers Delwyn L · Ochlocknee, GAN704DZWest Michigan Flying Club Inc · Norton Shores, MIN704EGMartinez Stephen D · Belton, MON704ELLancaster Aero LLC · Smoketown, PAN704EMFee Eaman · Pembroke, MAN704ERBeckwith James N · Goldsboro, NCN704EVJones Janet J · Burlington, VTN704EXMouw Jacob W H · Palmer, AKN704EZBellas Business LLC · Kalispell, MTN704FEOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeN704FKTb Maintenance And Cleaning LLC · Deltona, FLN704FNNorman Charles E DBA · Zanesville, OHN704FPKopache Gregory · Boulder, CON704FQLapinel Marc P · Long Beach, NYN704FWHorton Jimmie D · Orlando, FLN704FXKlingenberg Alice Ruth · Derby, KSN704FYWassair Aviation LLC · Elkhorn, WIN704FZDanto Peter J · Concord, CAN704GGillis Ryan T · Kenai, AKN704GCSteffen Craig · Harrogate, TNN704GDMacmorris Clifford Jr · Naples, FLN704GEPester Jerome · Hingham, MTN704GFDresti Mauro · Pomona, CAN704GGGorin Gustavo A · Statesboro, GAN704GKMcmullen Julie A · Skwentna, AKN704GRMellor James F · Spanish Fork, UTFirst renewal noticeN704GXHunt Greg · Rolling Prairie, INN704HBOtero Alberto A · Fort Pierce, FLN704HCBrown William C · Columbia, CAN704HDCleary John P · Worcester, MAN704HEFour Sisters Aviation LLC · Fayetteville, GA
Back to AD 94-05-05 R1