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.
N6482YSky West Aviation Inc Trustee · Albuquerque, NMN64834Golden Mahalo LLC · Sheridan, WYN6483AKdrcjt Aviation LLC · Orange, MAN6483FRegistration Pending · Seattle, WARegistration pendingN6483GPeterson Cassandra L · Poplar Grove, ILN6483SBlue Skies Aviation Of Wi Inc · Pulaski, WIN6483TFoothill Aviation LLC · Iliamna, AKN6484AState Of Illinois · Springfield, ILN6484FGrant Clinton A · Portage Des Sioux, MON6484XMeadows Robert H · Charleston, TNFirst renewal noticeN64859Leyva Maria · New Smyrna Beach, FLN6485EWitte Steven E · Egan, SDN64866Universal Aviators Academy Inc · El Monte, CAN6486AErickson Jon W · Union Grove, WIN6486BDevine Aviation LLC · Atlanta, GAN6486GRomeo Aviation Inc · Cumberland, WIN6486JSpredemann Carl A · Emmett, IDN64875Air America Flight Center LLC · Daytona Beach, FLN6487ALucci Giancinto A · Nashville, MIN6487BOneal Gary · Springdale, ARN6487DWayne County Airport Board · Monticello, KYN6487GRedell Donald J · Lake Geneva, WIN6487SSouth Louisiana Community College · Lafayette, LAN64882Blue Sky Flyers Inc · Greeley, CON6488EDanielson Austin Mb · Kenai, AKN6488FLee Michael R · Kelso, WAN6488GKrog Steven L · Hartford, WIN6488VThree Mayhoods LLC · Bonita Springs, FLN64892Montgomery Flying Club Inc · Montgomery, ALN6489EDupuis Normand G · Berlin, NHN6489HMoon Flight Aviation LLC · Barto, PAN6489XBargainnier Devin T · Carson City, NVN648BDHansen Robert C · Delavan, WIN648CPCivil Air Patrol · Maxwell Afb, ALN648DWDewhipet LLC · Sibley, LAN648FRegistered aircraftN648NHVenice Group LLC · Hopkinton, NHN648SPHillsboro Aero Academy LLC · Hillsboro, ORN64901Gwaviation Consulting LLC · Woodstock, GAN6490BPontoni Peter D · Athens, MIN6490DCampbell James W · Joshua, TXN6490XHansen Mark A · Traverse City, MIN64915Northwoods Air LLC · Orono, MEN64918Loeser Harold · Boca Raton, FLN64919Hawk III Flyers Club · Republic, PAN6491BTerrill Guy J · Dillon, MTN6491EToepfer Kendra · BielefeldN6491HBlue Air 3 LLC · Miami, FLN6491KFisher Air LLC · Cardington, OHN6491ZAndolina Richard F Jr · Hornell, NY
Back to AD 79-10-14 R1