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.
N9236HOptic Air LLC · Sioux Center, IAN9236TSpirit Engineering Inc · Grand Junction, CON9237BMenard Keith L · Bellevue, TXN92386Lee Eric H · San Diego, CAN9238ABryan Kirk J · Big Timber, MTN9238GSprang Pamela G · Newnan, GAN92399Hyland Flyers Inc · Coon Rapids, MNN9239XCarroll Bodo W · Franklin, OHN923AZN923az LLC · Miami, FLN923BRWings Of Grace Ministries Inc · Melbourne, FLN923CPCivil Air Patrol · Maxwell Afb, ALN923CTBragdon Emil · Fort Worth, TXN923DBGrenville Andrew · Decatur Island, WAN923DMHt Holdings LLC · Oxford, MSN923EC333 Ranch LLC · Elko, NVN923EDJust Plane Stuff Inc · Jackson, MSN923EPEpic Aviation Inc · New Smyrna Beach, FLN923EREmbry-Riddle Aeronautical University · Daytona Beach, FLN923GWCape Island Aviation LLC · Millville, NJN923JLdk Associates LLC · Colorado Springs, CON923SBGig Harbor Airplane LLC · Gig Harbor, WAN923STThompson Michael J · Nine Mile Falls, WAN92405Burgess Brian Keith · Arnoldsville, GAN92406Anderson George C · Centerville, UTN9240CMcbeth Seth C · South Salt Lake, UTN9240HPropability One LLC · Daytona Beach, FLN9240RAir Dakota Flite · Hettinger, NDN9240XN9240x LLC · Martinsville, INN92415Registered aircraftN92416Fly Guys LLC · Olympia, WAFirst renewal noticeN92419N92419 LLC · Manteo, NCN9241CBaranek Brian Patrick · Nikiski, AKN92422Mack Nester R · Utopia, TXN92424Christiansen Cortland · Bakersfield, CAN92428Woodall Richard J · Yakima, WAN9242ARobinson William A · Franklin, TNN9242GJones Reginald L · Baton Rouge, LAN9242HRoland Aviation LLC · Gualala, CAN9242RAir Dakota Flite Inc · Hettinger, NDN9242ULiggett Garrett C · Eminence, MON9242XB Roberts Aviation LLC · Clovis, CAN92433Vandervis Inc · Tulare, CAN9243FCig Aviation LLC · Littleton, CON9243HSeward Air Taxi LLC · Seward, AKN9243RC & L Holzwarth Inc · Virden, ILN9243XSchoo Peter L · Lewiston, IDN92445Pureflight Aviation Training LLC · Newberg, ORN92447American Patrols Inc · Midland, TXN92448Eckholt John · Forest Grove, ORN9244AKauffman Forrest J · Coolidge, AZ
Back to AD 79-10-14 R1