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.
N71298Belanger Patrick J Trustee · Gilroy, CAFirst renewal noticeN7129FDavis Clint H · Paola, KSN7129GSmith Lyle D · San Marcos, TXN7129QG Alaouie LLC · Port Austin, MIN712DAlpha Aviation LLC · Dalhart, TXN712EREmbry-Riddle Aeronautical University Inc · Prescott, AZN712JFN712jf LLC · Laveen, AZN712LULiberty University School Of Aeronautics · Lynchburg, VAN712MSNational Aircraft Leasing · Greenville, DEN712NVEpic Aviation Enterprises LLC · Austin, TXN712SPAmeriflyers Of Texas Inc · Addison, TXN712TCTeasdale Gregg N · Genesee, IDN712TTAb Cessna LLC · Wilmington, NCN712VAwf Aviation LLC · Calera, OKN712VTMiddle Fork Aviation Inc · Challis, IDN71300Finch Merry B · Marysville, CAN71305Fisher Vincent E · Burrton, KSN7130AJohnston David E · Fort Myers, FLN7130FRicker Gary L · Greeneville, TNN7130SHansen Christopher H · Durhamville, NYN71317Abbatiello Vincent Jr · Cape Coral, FLN7131AOneill Mark B · Pinckney, MIN7131ETravis Michael James · Burns, ORN7131FSchoch Brayden · Fort Pierce, FLN7131TReyes Jose Daniel Cruz · Wilmington, NCN7131XEaa Charter 1093 · Midland, MIN71320Wptd Inc · Munster, INN71321Boyle Christopher R · Truckee, CAN71323Air Legacy LLC · Chanhassen, MNN71326Lrc Aero LLC · Jacksonville, TXN7132QAero Quest LLC · Olive Branch, MSN71331Baird David W · Kanab, UTN71333Delaney Michael T · Edmonds, WAN71336Aviation Trust Company LLC Trustee · Oklahoma City, OKN7133APeacock Richelle L · Arcadia, FLN7133FCarrolls Auto And Aircraft Sales LLC · Muncie, INN7133QPage Aerial Service Inc · Rochelle, ILN7133TQuam Gary L · Rio, WIN7134FMejean Kenneth R · Brandon, FLN7134MTravis Craig W · Fallon, NVN71354Willis Enterprises · Enterprise, ORN71355Dal Tex Flyers Inc · Arlington, TXN71359Sparks Fly LLC · Mount Gilead, OHN7135AMoss Colin · Sparta, NCN7135FMiller Joseph A · Amissville, VAN7135QHoman Larry E · Sigourney, IAN71369Gosney James R Trustee · Silver City, NMN7136ACross Frank · Huntsville, MON7136ECreel Jeffrey G · Gaylesville, ALN7136GFairchild Natalie J · Drummond Island, MI
Back to AD 79-10-14 R1