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.
N6350BLefeve Douglas H · Cedar Park, TXN6350DMazza Salvatore M · West Creek, NJN6350EAirport Bums Aero Club · Branson, MON6350GZimny Daniel M · Rancho Cordova, CAN63512New England Aviation LLC · Plainville, CTN63515Rivera Jaime · San Antonio, TXN6351EMaluda Erick · Enigma, GAN6351GWhirling Wings LLC · Lexington, NCN63524New Garden Township · Landenberg, PAN63525Mickler Andrew E · Wasilla, AKN63526Pollard Charles A · Eau Claire, WIN6352ERotter Dale H · Colville, WAN6352FFletcher John G · Diamondhead, MSN6352GJohnson Jeffrey L · Paradise, CAN6352VMiles Richard A · Macon, NCN6352ZSale Reported · Anchorage, AKSale reportedN63532Seniram Air Inc · Wilmington, DEN63533Rue Levi G · Sheyenne, NDN63534Gaudet Edward · Winthrop, MEN6353ACypress Soaring Inc · Hemet, CAN6353DDeland Aviation LLC · Deland, FLN6353MMont Belvieu Materials Inc · Mont Belvieu, TXN6353UBas Part Sales LLC · Greeley, CON63543Turner Jeffrey L · Sour Lake, TXN63547Puppy Dog Aviation LLC · Anchorage, AKN63548Hoyle Jason · Grove, OKN6354BSgc Soaring Foundation · Bellevue, WAN6354KAvenge Holdings LLC · Ashburn, VAN63550Reid Edwin T · Lake Charles, LAN63554Nuovo LLC · Portland, ORN63556Tietje Barry N · Elton, LAN6355BRich Lucas Aircraft Sales LLC · Lincoln Park, NJN6355CDutch Air LLC · Kalispell, MTN6355EMassey David A · Yuba City, CAN6355KCiampa B Frank · Greenwood, INN6355SLudmerer Victor J · Greenwood Lake, NYN63565Cape Fear Aviation Maintenance LLC · Fayetteville, NCN63569Eastern Kentucky University · Richmond, KYN6356AFetterolf Zachary D · Athol, IDN6356BStaudacher Nicholas R · Midland, MIN6356ENielsen James Patrick · Chugiak, AKN6356GBettega Gerald E · Lutz, FLN6356STurner Dale W · Moore Haven, FLN63575Christensen Koufax · Norman, OKN63579Ollmann Paul W · Poplar Grove, ILN6357DRice John Jr · Maddock, NDN6357XMaanum Scott R · Park Rapids, MNN63580Registration Pending · Newbury Park, CARegistration pendingN6358ATop Aircraft Leasing LLC · Wilmington, DEN6358EStanford Point LLC · Kalispell, MT
Back to AD 79-10-14 R1