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.
N2516HFolk George W · Martinsburg, WVN2516LFlores E Alex · Missouri City, TXN2516NBigby Greg A · Reno, NVN2516ULofton Johnathan V · Springer, OKN2516YSchutjer Dennis · Clear Lake, IAN2517JRegistered aircraftN2517LCarroll Mark E · Nicholasville, KYN2517YEbnet Joel · Holdingford, MNN2518DKimball Arthur C · Long Beach, CAN2518KGolden Coast Airways Corp · Carolina, PRN2518NLittle Birdy Aviation LLC · San Antonio, TXN2518VFile Thomas A · Shoreline, WAN2518YTracy Michael S · Homer, AKN2519L2 G Group LLC · Honolulu, HIN2519UBradford Murvin L · Hensley, ARN251CMetsger Cecil P · Haughton, LAN251DTSwift Action LLC · Akron, OHN251RTRunyan Roger L · Carlton, PAN2520EBerke Jarett · Hanover, NHN2520LPeck M Hayden II · Bells, TXN2520NJavarey David J · Corning, NYN2520VSmith Gregory A · Lewistown, MTN2521CJago River Holdings LLC · Fairbanks, AKN2521LExpert Construction Services LLC · Mclean, VAFirst renewal noticeN2521YClanin James Robert · Vandalia, OHN2522JGrowden David C · Bedford, PAN2522WHollenbeck William M · Montrose, CON2523CMchenry Thomas Michael Jr · Indialantic, FLN2523DThomsen Richard · Ladera Ranch, CAN2523EWeimer Adam Jr · Fort Morgan, CON2523FCavin Dale L · Marianna, FLN2523HShadd James A · Lancaster, OHN2523NTourtelotte Joel H · Newburgh, MEN2523YLawson Matt E · Gobles, MIN2524DSutton Aircraft Salvage LLC · Palmer, AKN2524LGraham Jacob W · Rose Hill, KSN2524VJohnson Randon · Snowflake, AZN2524YPaul Danny W · Locust Grove, GAN2525CWeishaar Pilot · Odessa, WAN2525DStephan Andrew Ryan · Eagle River, AKN2525ERegistration Pending · Duluth, MNRegistration pendingN2525JHector Lionel · Paisley, FLN2526EGrotewohl Chris · Roeland Park, KSN2526NBlair Stanley P · Fort Myers, FLN2526YJahnke Ryan M · Grafton, WIN2527BRegistration Pending · Wasilla, AKRegistration pendingN2527CDuffy Lawrence R Jr · Vinemont, ALN2527FHightower Marc S · Sevierville, TNN2527JHunt Wayne A · Delta Junction, AKN2527LWooten Craig J · Campobello, SC
Back to AD 94-05-05 R1