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.
N6983EBurkhardt Charles P Jr · Norco, CAN6983GGoemmel Steven J · Airway Heights, WAN6983HWaddell Pap LLC · Friendswood, TXN6983XOptivol Corp · Miami, FLN6984GCoffel Alexander · Meridian, IDN6984XFive Delta Sierra Inc · Pembroke Pines, FLN6985AImwalle John N · Batavia, OHN6985EThomas Steven J · Wasilla, AKN6985GBustamante Wilton F · Whitsett, NCN6985XNazario Juan A · Orlando, FLN6986APoindexter Charles A Sr · West Point, MSN6986SKass Deborah J · Chandler, AZN6986XMcallister Paul · Delafield, WIN6987FGacesa Samuel M · Belton, TXN6987SHubbard Broadcasting Inc · Saint Paul, MNN6988ARegistered aircraftN6988EPeterson Andrew B · Louisville, KYN6988FPaulson Allerton · Anoka, MNN6988XPaul Aviation LLC · Wasco, CAN6989MRp Wellons Aircraft LLC · Dunn, NCN698JABon Bon Aviation LLC · Daly City, CAN698MCRegistered aircraftN698SPFoothill Aircraaft Sales & Service Inc · Upland, CAN6990EGray Jade · Odessa, TXN6990FWohlers Paul A · Calimesa, CAN6990YV Speed Aviation LLC · Reno, NVN6991EHiggins Frank E · Rio, WIN6991FMeyer George D · Paradise, CAN6991GMid South Aircraft Sales Inc · Glencoe, ALN6991HRhinelander Flying Service Inc · Palmetto, FLN6992EMikkelsen John P · Sebastopol, CAN6992FJenkins Seth A · Charlotte, NCN6992GMosch Edward C · Indialantic, FLN6992XBurleson James R · Snyder, TXN6993AHurta Jennifer · Cypress, TXN6993ENewberry Wilma L · West Paducah, KYN6993FBordens Jacob R · Chatham, NJN6993NSp Aircraft LLC · Moscow, IDN6993VRegistration Pending · Harvey, NDRegistration pendingN6994AMeador George D · Austin, TXN6994FHerring Jason D · Wasilla, AKN6994HMach 2 LLC · Fairbanks, AKN6994MParish John L Sr · Tullahoma, TNN6994XVossler Kevin D · Bismarck, NDN6995EBennett Jeffrey S · La Mesa, CAN6995SNaylor Aviation LLC · Scotch Grove, IAN6995XWarmkessel James R · Felton, CAN6996HWeirich Gayle M · Rockford, MIN6997AAirpower Aviation Resources Inc · Newbury Park, CAN6997FSmith Roger D · Fayetteville, NC
Back to AD 79-10-14 R1