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.
N6333BEspiricueta William L · Denver, CON6333EProstar Flight Services LLC · Bozeman, MTN6333FMattuski Joseph C Jr · Parker, COFirst renewal noticeN6333GEule James M · Eagle River, AKN6333SVano Andrew · Carlos, MNN63341Puget Sound Flyers Inc · Everett, WAN63342Vmax Aviation LLC · Uhrichsville, OHN63346White Thomas L · Willow Springs, MON6334BS&D Spraying Service Inc · Panhandle, TXN6334ESrygley Donald E · Muscle Shoals, ALN6334WColwell Kevin · Middleton, WIN63352Carter Flygare Inc · Sacramento, CAN63359Flick Adam C · Findlay, OHN6335ECorro Lee A · Holden, MEN6335GHaslam Russell L · Meeker, OKN6335ZLs Express LLC · Syosset, NYN63362Bels Holdings LLC · Albert Lea, MNN63363Shaner John D · Tallahassee, FLN63366Purdue Aviation LLC · West Lafayette, INN63368Lorenzen Kraig Elmer · Pagosa Springs, CON6336BNorris Donald A III · Edmond, OKN6336KFlanders Steve L · Brea, CAN6336UBravo Whiskey LLC · Missoula, MTN6336VKman LLC · Kalispell, MTN63371Flight Training Aircraft LLC · Wilmington, DEN63375Pocono Mountains Flying Club Inc · Tobyhanna, PAN63376Devaney Aviation Inc · Palm City, FLN6337AAilf Marketing LLC · Port Charlotte, FLN6337BMckee Bradley Cole · Taylor, TXN6337DHomerace Inc DBA · Tulsa, OKN6337KK-Ville Flyers LLC · Newmanstown, PAN6337VFirelight Ventures LLC · Fuquay Varina, NCN6337XUnique Educational Experiences Inc · Long Beach, CAN63384Sa Kim J · Hayward, CAN6338ALittle Bird Airways LLC · Hamburg, NYN6338BSlad George W · Albuquerque, NMN6338DEdb Air Inc · Wilsonville, ORN6338EBarber Theodore C Trustee · Spanish Fork, UTN6338FRaritan Valley Flying School · Princeton, NJN6338GEron Patrick · Hatley, WIN6338KBurchinal Sam F · Brookston, TXN63395Reiman Jeffrey Scott · Chandler, AZN63399Vogt Gerald J · Erie, PAN6339AHockenberry Tyler F · Royse City, TXN6339CBowles Donald E Jr · Dallas, TXN6339DContrails II Inc · Kerrville, TXN6339EJudge Nathan E · Coeur D Alene, IDN6339SDamico Thomas J · West Bend, WIN633BCOneal Brittany H · Palestine, TXN633CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 79-10-14 R1