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.
N4366BLittle Andrew P · Fairbanks, AKN4366RHyland Mark R · Poland, MEN4366UScott Michael D · Chippewa Falls, WIN4369BFlegel Brian E · Milton Freewater, ORN436AGSkywest Leasing Inc · St George, UTN436CAWingsleasing LLC · Wichita, KSN436CSBulovic Mark · Savannah, GAN436PWRegistration Pending · Walnut, CARegistration pendingN436RMRocky Mountain College · Billings, MTN436SAClark Vernon · Olalla, WAN436SPHillsboro Aero Academy LLC · Hillsboro, ORN436THSnohomish Flying Service Inc · Snohomish, WAN4370LAir North Flying Club · Malone, NYN4370RSkar Paul R · Londonderry, NHN4370UNeal Gordon T · Massillon, OHN4371LPrisk Jack J · Pride, LAN4371UBarnett Gina L · Columbus, TXN4373BZenishek Gary D Trustee · Jefferson City, MON4373LWilliams Matthew W · Fort Walton Beach, FLN4374QWillaero LLC · Union City, TNN4376QFranke Russel G · Silt, CON4377BNatural Resources LLC · Arcadia, FLN4377QStacey James · Exeter, MEN4377RDallas Aero & Sales LLC · Poplar, MTN4378LRegistration Pending · Wentzville, MORegistration pendingN4378QWings Flying Club Inc · South Bend, INN4378UWissenbach Richard G · Pinesdale, MTN4379BNewell Kenneth L · Wichita, KSN4379QHagaman Edward T · Tolland, CTN4379RSlipstream Aviation LLC · Calera, ALN437EPAb Prop Plane II LLC · Metairie, LAN437FAWhiskey Charlie Aero LLC · Poway, CAN437PHHolske Peter John · Dartmouth, MAN437PSWest Michigan Aviation Academy · Grand Rapids, MIN437SPN437sp LLC · Manassas, VAN4380BThorall Kenneth L · Chugiak, AKN4381BBuck William A · Waianae, HIN4381QAero Wise Services LLC · Decatur, TXN4381RDugan James M · North Bend, OHN4382BBoyd Delbert L · Oroville, CAN4382LFielding Gregory J · Holland, MAN4382QLegends Air LLC · Wilmington, DEN4382RMoranski Joseph F · Budd Lake, NJN4382U82 Uniform LLC · Tremonton, UTN4383LHasman Robert B · Flushing, MIN4383QBladen Aviation Inc · Elizabethtown, NCN4384BMead Aviation LLC · Missoula, MTN4384KLewis Flying Service Inc · Morse, LAN4384QMorten John E · Larimore, NDN4384RAmerican Patrols Inc · Midland, TX
Back to AD 79-10-14 R1