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.
N5367RBrooks Gordon B Sr · Hot Springs, SDN5367SMedvetsky Dennis · Lincoln, RIN5367TJulian Farm LLC · Hudson Oaks, TXN53687Gessel Todd W · Phoenix, AZN53688Moll Jeffery A · Hubertus, WIN5368AValiair Limited Co Trustee · Casper, WYN5368BGachis Gary Allen · Vacaville, CAN5368QMobley Christopher M · Keysville, GAN5368RBiggs Aircraft Inc · Wellston, OKN5368UBornwasser Louis W · Prospect, KYN5369AMartens Charles H · Nokomis, FLN5369CLowe David · Sacramento, KYN5369DBrown Hector M · Glenwood Springs, CON5369NDecio Justin M · Portsmouth, NHN5369QAirfleet Solutions LLC · Newark, DEN5369RArmbruster LLC · Amherst, OHN5369YPollard William Edward · Big Spring, TXN536EREmbry Riddle Aeronautical University Inc · Prescott, AZN536GRNational Aircraft Leasing Corp · Greenville, DEN536HFVan Anda Aviation LLC · Apopka, FLN536JRSale Reported · Port Orange, FLSale reportedN536KSKent State University · Stow, OHN536LAhmed Ejaz DBA · Carrollton, GAN536NDPhoenix East Aviation LLC · Daytona Beach, FLN536SPEastern Cincinnati Aviation · Batavia, OHN536THLanier Equipment Leasing LLC · Gainesville, GAN536WCN8qb LLC · Thief River Falls, MNN53703University Of Michigan Flyers Inc · Ann Arbor, MIN53704Renforth Michael · Yorktown, VAN53708Registered aircraftN5370DWhitten Wayne M Sr · North Berwick, MEN5370ESwanson Philip A · Star, IDN5370UPogany Steve C · Anchorage, AKN53710High Paint Aviation LLC · Smyrna, SCN53716Cameron Thomas J · Stanchfield, MNN5371KExecutive Aviation LLC · Peoria, AZN5371LKamel Lance J · Plantation, FLN5371QTimber Creek Flyers Lc · Albion, IAN5371RAirglas Inc · Anchorage, AKN5371XMarks Max · Cape Elizabeth, MEN53720Christiansen Aviation LLC · Wilmington, DEN53725Registration Pending · Honolulu, HIRegistration pendingN5372DHanks Don N · Eagle River, AKN5372VCooper'S Hawk Aviation LLC · Rochester, MIN5373CJoy Solutions LLC · Wilmington, DEN5373QMallatt Michael N · Galena, KSN53742Mh Aviation Inc · Lancaster, CAN5374CPaulson Chris M · Eatonville, WAN5374DMoreau Clair L Jr · South Portland, MEN5374JMiles Brian R · Lake Jackson, TX
Back to AD 79-10-14 R1