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.
N8973VOcean Flyers LLC · Chatham, NJN8974BWaller Steven M · Sterling, CON8974GPike Vincent I · Bagdad, AZN8974SRegistration Pending · Bentonville, ARRegistration pendingN8974XHarris Warren R · Mccleary, WAN8975VMauser James E · Zionsville, PAN8976GTeeray LLC · Mountain City, TNN8976SHattaway Laura C · Rossville, GAN8976TKumm John J · Clarkston, WAN8977TAllsup Delmar D III · Oakhurst, CAN8979SFurtadobradley D · Lodi, CAN8979TNardi Patty K · Missoula, MTFirst renewal noticeN8979VAvel Aircraft Inc · West Chicago, ILN897AFAmeriflyers Of Texas Inc · Addison, TXN897AHAerospace Asset Holdings LLC · Wilmington, DEN897CPCivil Air Patrol · Maxwell Afb, ALN897EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN897LPMarcus Air LLC · Plano, TXN897SMDomich Jeffrey E · Petaluma, CAN8980TN8980t LLC · Dallas, TXN8980VSweitz-Air Inc · Stewartstown, PAN89811Sky Warrior Flight Training Inc · Pensacola, FLN8981TCharlie Tango LLC · Rapid City, SDN8981XBales Philip J · Chandler, AZN8982TLarson Lynn R · Casselton, NDN8982VHirsch John K Trustee · Gerald, MON8983BMcguire Zach T · Jasper, MON8983VMoon Reagan E · Bossier City, LAN8984BWhelchel Neil E · Joshua Tree, CAN8984XSkydive Florida Keys Inc · Summerland Key, FLN8985SOrganization Of Black Aerospace Professionals · Westchester, ILN8985TDonald V Johns Jr · Rush, CON8985XHill Jack · New Lenox, ILN8986SSchneider Jackson L · Florissant, MON8986UJmt Aviation LLC · Bel Air, MDN8986VAirline Transport Professionals Corp Of USA · Wilmington, DEN89878Corwin Shawn M · Tucson, AZN8987BHoover Rowdy L · Owasso, OKN8987TPeavy Magnus Delacy IV · Crawfordville, FLN8987VPiper Capital Growth Fund LLC · Scottsdale, AZN8988UQuestair LLC · Madison, MSN8988VWahle Daniel C · Missoula, MTN8989MSkymaster Mods & Parts LLC · Castalian Springs, TNN898AHAerospace Asset Holdings LLC · Wilmington, DEN898BPetropulos James J · Juneau, AKN898BHPompa Oliver · Tuscon, AZN898HCSmith Andy · Fitzgerald, GAN898SWHealy Ronald L · Anchorage, AKN898TMKingsley Kaland W · Miller, MON8990BSortomme Jeffrey P · Sacramento, CA
Back to AD 79-10-14 R1