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.
N453CMUniversity Of Central Missouri · Warrensburg, MON453EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN453LPFrsp LLC · Watkins, CON453MCMcneil Kenneth A · Fort Meade, FLN453PTHenrie Aviation LLC · Fairfield, NJN453SPUnited States Air Force Owner · Elmendorf Afb, AKN45407Westrup Gregory W · Greensburg, INN4541CPolsley Christopher · Galion, OHN4541FWittnebel Karl · Los Angeles, CAN4542BWilliamson Charles F · Ocean Isle Beach, NCN4542CThomas Scott A · Groveland, CAN45430Coffield Alan B · Canyon Lake, CAN45434Urban Aviation Services Inc · Paxton, MAN4543BGrandy Glen E · Placerville, CAN4543CSkog Ken · Riverside, CAN45446Coronel Juan M · Elk Grove, CAN45449Beckett Michael O · Roy, WAN45454Aero Flight One LLC · Peoria, AZN45456Oakhill Aviation LLC · Wasilla, AKN45459Quirk Charles Leo · Lake Charles, LAN45467Airnolimits LLC · Palm Coast, FLN4546CHoffman Gregory E · Fairbanks, AKN4546FThomas Craig E · Stevensville, MTN4546UHarrier Soaring Club Inc · Raleigh, NCN45471Verhoeven Mathew M · Avondale, AZN45473N2flyingaviation LLC · Foxworth, MSN45478Unertl Robert C · Columbus, WIN4547EG&M Aircraft Inc · Wheat Ridge, CON4547URegistered aircraftN-number assigned, not yet registeredN4548BSchad Anthony J · Oceanside, CAN4548FWard Nelson H · Salcha, AKN4548UHaan James J · Norton Shores, MIN45491Birdwin LLC · Buras, LAN45496B&R Aircraft LLC · Wadsworth, OHN4549CWatsons James W · Fairbanks, AKN4549FMetroaire LLC · Mc Kees Rocks, PAN4549UJmh Futures LLC · Gilbert, AZN454AGAb Prop Plane II LLC · Metairie, LAN454BMCorman David L · Lovington, ILN454CMUniversity Of Central Missouri · Warrensburg, MON454GGAk Air Leasing LLC · Homer, AKN454SVEcliax LLC · Craig, AKN4550BHickle William H · Inyokern, CAN4550CBrown Larry A · Mesa, AZN4550EPommy & Swede LLC · Valentine, NEN4550UGreene County Holdings LLC · Albany, NYN45510Hansen Albert C · Mojave, CAN45511Sb Aviation LLC · Gowanda, NYN45512Caponio & Sons Inc · San Francisco, CAN45520Frazier John C · Oxford, NC
Back to AD 79-10-14 R1