AD 94-05-05 R1
Registered aircraft · 26,231
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.
N3457DParker Greg · Denham Springs, LAN3457KNeff Michael K · Salem, INN3458CThurmond Roger D · Wasilla, AKN3458DMarquardt Paul M · Rhinelander, WIN3458JHoughton Raymond A · Fort Bragg, CAN345CCLawton Matthew S · Eagle River, AKN345EEKielich Darryl C · Elk Grove, CAN345QASale Reported · Leesburg, FLSale reported, pending cancellationN3460VDegeorge Richard L · Cape Coral, FLN3461JSmith Stephen T · Hale, MIN3462CGivens Benjamin T · Ruffin, SCN3462DKudner Donald T · Maumee, OHN3463DBrown Theodore A · Trivoli, ILN3464COlson Donald C · Golovin, AKN3465DGold Prop Aviation LLC · Auburndale, FLN3466DSmith George L · Watervliet, MIN3466JSale Reported · Fruita, COSale reportedN3467CShaw Brian W · Bemidji, MNN3467DNorth Lake Air LLC · Lindstrom, MNN3467JKlempel Reuel D · Eltopia, WAN3468JC&C Aero LLC · Billings, MTN3469BOliver Daniel R · Cincinnati, OHN3469CSoroka Stephen W · Eagle River, AKN3469EJohnson Ray L · Marion, INN346BJDixon Craig S · Rimrock, AZN347Haugen Michael C · Oklahoma City, OKFirst renewal noticeN34705Wings Den LLC · Wilmington, DEN3470CMoorhead Equipment LLC · Belton, SCN3470JEdson Vincent · Auburn, CAN3471HPritchett Otis R · Avery, TXN3471JLogtime Flight LLC · Lancaster, TXN3472CTotal Tailwheel LLC · Weston, MAN3472NHoover Michael B · Ridgeland, WIN3474CLeroux Todd Carl · Palmer, AKN3474NHight Melanie · Washington, DCN3475VSatterlee Michael E · Clever, MON3475ZReynolds Clark L · Rozet, WYN3476CDitzler Kevin J · Kirkland, WAN34776Eckberg Robert K · Dakota City, IAN34778Dart Gregory G · Mayville, NYN3477HSprott Robert L · Perkins, OKN34785Western Antique Aeroplane & Automobile Museum · Hood River, ORN3478CSchumacher Brent A · Inchelium, WAN3478VGazsy William · North Bellmore, NYN34791Hays James B · Early, TXN3479DGeier Harry J · Huntington Beach, CAN3479EWhite Bill E · Estacada, ORN347CRHirsch Randall L · Mc Donald, TNN3480CEffenberger Anthony J · Mankato, MNN3481DDavis Tyler M · Moreland, GA
Back to AD 94-05-05 R1