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.
N543DGGavora Daniel E · Fairbanks, AKN543EMPacific Air Flight School LLC · Long Beach, CAN543EREmbry-Riddle Aeronautical University Inc · Prescott, AZN543JRRahns Inc · Enterprise, ORN543MCJoe Morten & Son Inc · S Sioux City, NEN543NDN543nd LLC · Manassas, VAN543THRidgeline Assets LLC · Wilmington, DEN543VKHuffman Jacob M III · Burleson, TXN5440BCline Thomas E · Santee, CAN5440EK & A Aviation Inc · Barnegat, NJN5440KTwenty Two Juliet LLC · Tyler, TXN5440NKenosha Airmens Flying Club Inc · Twin Lakes, WIN5440TIsland Lady LLC · Iowa Falls, IAN54413Belcher Phillip B · Claremore, OKN5441BFour One Bravo LLC · Piedmont, SCN5441HKlein Darrell J · Deland, FLN5441RGraham Norman J · West Ossipee, NHN5441TCape Steven A · Columbia, KYN5442EUnterseher Pat L · Kearney, NEN5442HJones Gareth B · Goldsboro, NCN5442NDeruwe Karl J · Othello, WAN5442RBarnes Terry A · Austin, TXN5443VTurk Aviation LLC · O Fallon, ILN54448Jupiter Flight Service And Investing LLC · Lithonia, GAN5444CMathis Ryan B · Madison, ALN5444HIowa Lakes Community College · Estherville, IAN5444JHm Aviation LLC · Cape Fair, MON5444QChiavari Nicholas J · Havertown, PAN5444RAlpha Romeo Aviation LLC · Phoenix, AZN5444TTappon Wayne A · Ladysmith, WIN54452Epling Kenny B · Mechanicsville, VAN5445BWilds Terrance L · Grand Rapids, MIN5445RWimpy Gregory S · Griffin, GAN5445TSchallip Robert G III · White Lake, MIN5446BDavis Elizabeth · Flagstaff, AZN5446CKing Larry R · Knoxville, TNN5446DJ And D Petroleum Co · Tallahassee, FLN5446HBlizzard William F Jr · Barboursville, WVN5446SDelgado Alvaro A · Orange, VAN54477Hillsboro Aero Academy LLC · Hillsboro, ORN5447KFly For Fun LLC · Frederick, MDN5447RToth Roger J · Willoughby, OHFirst renewal noticeN5448BDesjardins Norman W · Gresham, ORN5448CBeamer Nicholas J · Yuba City, CAN5448NRadial Enterprises LLC · New Carlisle, OHN5448RBuby Lloyd F · Mannington, WVN5448TRegistration Pending · Las Vegas, NVRegistration pendingN5449HMoorhead Aviation Services LLC · Moorhead, MNN5449QHarper Randall W · Presque Isle, MEN5449RMartin David · Waterport, NY
Back to AD 79-10-14 R1