AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N8904XPlanes Of Fame Air Museum · Chino, CAN8905BGamble Dennis H · Cottonwood, ALN8906SHoskins Brent E · Caldwell, IDN8906TTln Aviation LLC · Stanwood, WAN8906VLewis David A · Broadalbin, NYN8907BRaven Aviation LLC · Lexington, KYN8907GInfinity Aviation · Pine Island, MNN8907QBurks Excavation Corp · Hailey, IDN8907VSmith Melvin Roy · Gulf Breeze, FLN8907XFrey Harlan Jerome · Carey, OHN8908BAxmacher Mark A · Hillsboro, OHN8908TWinit Matthew C · Woodland, WAN8909TFinley Steven V · Fort Collins, CON8909XHubbert Stephen B · Owasso, OKN890CPCivil Air Patrol · Maxwell Afb, ALN890EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN890KCMustang Sally Aviation LLC · Camden, SCN890MBVan Bortel Aircraft Inc · Arlington, TXN890PGCp Air LLC · Indianapolis, INN8910BStone Tim · Siloam Springs, ARN8910TSaa Enrique A · Lubbock, TXN8910XElardi Frank Paul · Upland, CAN8911BPeterson Clifford H · Old Town, MEN8911SPriglmeier Mark L · Deerwood, MNN8911VHorizon Dreams LLC · Homer, GAN8912VRoper Jeff A · Corralitos, CAN8912XAman Douglas A · Fairfield, ILN8913VI'Ll Fly Away LLC · Florence, SCN8914SCarroll Louis · Perris, CAN8914XHawkins William A · Euless, TXN8915GFerdon Richard P Trustee · Fort Mohave, AZN8916BSanborn George A Sr · Culver, ORN8916GSorenson Robert H · Forsyth, MTN8916VTaylor William W Jr · Hudson Oaks, TXN8917BTederman Terri Lynn · Auburn, WAN8917XCleveland William B III · Canal Fulton, OHN8918TAirtime LLC · Wilmington, DEN8918XRtillery Services LLC · Holdrege, NEN8919TUllmann Wilmer R · Fairview, TXN8919VChristiansen John · Vicksburg, MIN891CPCivil Air Patrol · Maxwell Afb, ALN891SPSkydive Pennsylvania · Mercer, PAN891SROmalley Benjamin P · River Falls, WIN8920SWefald Richard I · Jordan, MNN8921TRoberts Marty · Mount Hermon, LAN8921VN2827n LLC · Pembroke Pines, FLN89225Lucky Dog Aviation LLC · Victoria, TXN8922VTampa Bay Aviation Inc · Clearwater, FLN8923SHuang Chen · Chino Hills, CAN8923VMollica Richard Anthony · Oxnard, CA
Back to AD 79-10-14 R1