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.
N8645URocereta Aaron W · Eagle River, AKN8646QPoe Asphalt Paving Inc · Lewiston, IDN8646SFoster Brian E · Bartley, NEN8647MWestern Skymasters LLC · Salt Lake City, UTN8647QTechnical Applications & Consulting LLC · Topeka, KSN8647TJones Wallace F · Waterford, MEN86487Flohr Linn C · Allons, TNN8648GAugust Aero LLC · Kalispell, MTN8648SSnodgrass Gavin I · Belle, MON8649GMullins Steve F · Belews Creek, NCN8649SGuffey Edward B · Bessemer City, NCN8649TJarosak Peter J · Valparaiso, INN864AKNorthern Waters LLC · Livingston, MTN864AUAuburn University · Auburn University, ALN864CKTabatabai Seyed Ali · Houston, TXN864CPCivil Air Patrol · Maxwell Afb, ALN864PAMorris David · Fort Mill, SCN864SPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeN864TGTouch N Go Aeroworks LLC · Greenville, SCN864TWTailwinds Academy Of Aviation · Philadelphia, PAN86508Kalweit Reginald A · Page, AZN8650BKing Kenneth M · Charleston, SCN8650SGrant Clinton A Trustee · Portage Des Sioux, MON8650ZBarry Russell L · Fort Mohave, AZN86510Ungersma Thomas Robert · Belgrade, MTN86513Northern Air & Ag Inc · Pollock, SDN86526Hill Farms Inc · Drexel, MON8652SKindel Michael W · Bismarck, NDN8652TEagles Wings Inc · San Angelo, TXN86536Moes Crop Dusting Service Inc · Marysville, CAN86537Beck Kenneth C · Gig Harbor, WAN86539Skymaster Stc LLC · Mena, ARN8653GArmstrong John K · Lovington, NMN8653UCurtis Heather · Fairbanks, AKN86541Hyppa Russell F · Cook, MNFirst renewal noticeN8654UThompson George C · Rogersville, ALN8655BFredrickson Sherman E Jr · Norman, OKN86567Ireys Charles G · Tok, AKN8656JMeyer Eric Trustee · Moscow, IDN8656THacker Arlen H · Sandusky, MIN8657GClayton Patrick D · Hazen, ARN8657JCompany Air LLC · Bermuda Dunes, CAN8657URidley Timothy A · Uniontown, PAN8657XFlolid Ron · Little Falls, MNN8658GWestrum Sean Ross · Norwalk, IAN8658SBird Jared N · Mission, TXN8658XNorth Mountain Lake Corp · Wilmington, DEN8659GCoker Jason John · Caribou, MEN8659JThomas Chase D · White Oak, TXN8659QAlexander Harold W Trustee · West Richland, WA
Back to AD 79-10-14 R1