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.
N3481ESokolowski Diane M · Clear Lake, IAN3482CLacewell Matthew K · Chugiak, AKFirst renewal noticeN3482DKrumins Arvids · Wichita, KSN3482JShelton David R · Potter Valley, CAN3483CBorreson Michele R · Reno, NVN3483ZRiggin Flight Service Inc · Madison, SDN34846Irwin Jeremy D · Sabina, OHN3486CZachary Maydole · Fairbanks, AKN3486VLiberty Aviation LLC · Henderson, NVN34875Rule Paul Crane Trustee · Wapato, WAN3487CWhitten Chris K · Alton, MON3487DSowles John W · North Yarmouth, MEN3487KMcclean James A · Springfield, MON34881Dietz Carroll F · Rockford, ILN3488CBaker Dean C · Cave Creek, AZN3488DSugarloaf Aviation LLC · Carrabassett Vly, MEN34890Trier Mark S · Cle Elum, WAN3489CBurward-Hoy Trevor · Cupertino, CAN3489VMathews Richard III · Cuthbert, GAN3491CNorth Sound Aviation Inc · Sedro Woolley, WAN3491JNightknight LLC · Palm Bay, FLN3492CPiscoya Thomas G · Anchorage, AKN3493CLumland Properties LLC · Winchester, VAN3495DBruck Solomon A · Van Nuys, CAN3495JWatson John T Jr · Fairfield, CAN3495NOld Goat LLC · Wilmington, DEN3495VSignal Air Service Inc · Gallatin Gateway, MTN3496DBengtson David M · Van Alstyne, TXN3496KKruckeberg Kevin P · Fishers, INN3496VRasch James L · Conklin, MIN3497CDavids Robert A · Angels Camp, CAN3497DBeckman Steven J · Parker, CON3497NBennet Jonathan M · Montauk, NYN3498CBowen Miles C · Brighton, MIN3498DHeitz John W · Manvel, TXN3498JThompson Rick L · Chico, CAN3499DSnell Robert B · La Vernia, TXN349ACFrets Glynn · Gainesville, GAN349ADEdelman Loren H · Sabetha, KSN34APPitman Amanda R · Harrah, OKN34CLBarrett Benjamin C · Gorham, MEN34EZWillis Kevin J · Andrews, NCN34GMinerva Keith R · Jacksonville, FLN34JDHemphill Holdings LLC · Hemphill, TXN34LNAshley James M · Greenwood, SCN34SBWeishaar Wallace · Livingston, TXN34TDHartwig Samuel H · Neelyville, MON34TKWilkinson Paul R · Colonial Beach, VAN34VELane James D Jr · Raleigh, NCN34XMMeaders Justin D · Fort Worth, TX
Back to AD 94-05-05 R1