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.
N6928MJohnson Mark D · Onondaga, MIN6928SPoling Brett Tyson · Saint Francis, KSN6928XN6928x LLC · Sandpoint, IDN6929Monsen Ronald · Naperville, ILN6929AWadsworth Curtis D · Sierra Vista, AZN6929FRyberg Keith C · Portales, NMN6929JMhz5620 LLC · Fitchburg, WIN6929RShelfer Douglas · Arlington, TXN692CPCivil Air Patrol · Maxwell Afb, ALN692MADevine James W · Columbus, OHN692SPSmith Holdings Inc · Wilmington, DEN6930AStewart Donald M · Vulcan, MIN6930FWright Dale D · Wallace, KSN6931GWoody Eric · Candler, NCN6931RFender Darrell L · Garfield, WAN6931XDanford Gary R · Columbus, MSN6932AAthey Jerry Jeff · Alvin, TXN6932GRonald O Holcomb LLC · Republic, MIN6932RBoxwell Avionics · Green Cove Springs, FLN6933ERulo Michael L · Westcliffe, CON6933GAltomari Richard · Pittsburgh, PAN6934SLet There Be Flight LLC · Portage, MIN6934XLunar Aviation Services LLC · Owasso, OKN6935FWood Roger E · Waxhaw, NCN6935XDetert Robert D · Rockdale, TXN6936AJordahl Amy L · Two Harbors, MNN6936HQuist Donald G · Ridgecrest, CAN6936MNortheast Florida Aero Club Inc · Fleming Island, FLN6936RKingrey William S III · Richmond, TXN6937FSale Reported · Rockton, ILSale reportedN6937HTreble Holdings LLC · Dover, OHN6937SCaum David A · La Porte, INN6938GRf Aviation LLC · Owensboro, KYN6939AErtas Efe Y · Walnut Creek, CAN6939FPayne Billy Jack · Powhatan, VAN6939NSky West Aviation Inc Trustee · Albuquerque, NMN6939RGalloway Kyle J · Bradshaw, NEN693DADirect Action Aviation LLC · Reno, NVN693SACaddo Aircraft LLC · Lewes, DEN6940XWestern Aircraft Leasing LLC · Tempe, AZN6941EMohagen Henry C · Reva, SDN6941FMorgan Stuart G · Spring Valley, CAN6941SBrowning Stephen D · Bear, DEN6942AHaskell Thomas L · Summerville, SCN6942EOakland Dennis E · Glennallen, AKN6942FGold Cap LLC · Bremerton, WAN6942HW Lance Orr · Gig Harbor, WAN6942VWaters Tracy J · Pittsboro, NCN6943ELasky Robert C · New Richmond, WIN6943GBoydston Tony C · El Paso, TX
Back to AD 79-10-14 R1