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.
N720FHParadigm Aviation LLC · Anchorage, AKN720GEHoucke Pascal · Newtown, PAN720LULiberty University Inc · Lynchburg, VAN720RKLong Philip Charles · Ojai, CAN720SBWhalen John F Jr · West Ossipee, NHN720WTBlain Monte W · Joliet, MTN721Department Of The Interior · Boise, IDN72106Dahl George Robert · Bethel, AKN7210GOgle Howard J · Moorpark, CAN7210MHensman Bruce E · Steamboat Springs, CON7210NHansen Arthur R · Cheyenne, WYN7210QAthol Orange Aero Club Inc · Athol, MAN7210SAccelerated Aviation Instruction LLC · Owatonna, MNN7210XStacey William B · Lebanon, TNN72113N72113 LLC · Harrah, OKN72117Ott Steve G · Reedpoint, MTN7211ATravis Michael B · Camano Island, WAN7211MGasvoda Richard S · Fairfield, MTN7211NGallacci Jefry S · Mattawa, WAN7211THargrove Nicholas A · Lago Vista, TXN7211XJenkins Joe C · Wyoming, DEN7212ABlane Steven C · Rockville, INN7212GMeister James A · Star Prairie, WIN7212MWarhus Donn M · Palmer, AKN7212QLink Air Service LLC · Minong, WIN7212XBurgess Sheldon · Raymond, MSN7213NSouth Aero LLC · Albuquerque, NMN7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIN7214MOldenkamp Timothy J · Palmer, AKN7214NThompson Jared N · Hayden, IDN7214TKennedy John M · San Leandro, CAN7215EPatton James Jay · Sequim, WAN7215QRhynette Airways LLC · Key Largo, FLN7215SHitt Bruce A · North Augusta, SCN7215TSmith Jon O · Leavenworth, WAFirst renewal noticeN7215XJackson Garrett J · Woodland, WAN72160Mccauley Thomas I · Puyallup, WAN7216EZeus Air Inc · Wilmington, DEN7216GLincoln Skyways Inc · Lincoln, CAN7216MStanton Andrew J · Platte City, MON7216QElias Close Deanna · Kenilworth, ILN7216TRk Air LLC · Wilmington, DEN7216XAmann David P · Wesley Chapel, FLN7217AMcguires Flying Service LLC · Obion, TNN7217ERomo Daryl · Anchorage, AKN7217GOne Niner Right LLC · Berkeley, CAN7217QRegistration Pending · Fond Du Lac, WIRegistration pendingN7217TDenney David W · Fowler, CON7217XGorman Byron E · Knife River, MNN7218AGurdak Paul J · Bristol, VT
Back to AD 79-10-14 R1