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.
N8354XWillow Equip LLC · Fox River Grove, ILN8355BBowen Jeffrey N · Jacksonville, NCN8355GGrant Jimmy L · Ada, OKN8355JPadilla Hector F · Mountain View, CAN8355MRcs Services LLC · California, MDFirst renewal noticeN8355QDelta Pacific Northwest LLC · Anchorage, AKN8355SFayette Hawks Flying Club Inc · Somerville, TNN8355TDakota Aircare Inc · Wagner, SDN8355UWilhelm Joshua Robert · Lake Havasu City, AZN8356AClinard Larry L · Escanaba, MIN8356ESky West Aviation Inc Trustee · Albuquerque, NMN8356MSporie George F · Marinette, WIN8356SHirlinger Saylor John Trustee · Stevenson Ranch, CAN8356UKolb Austin R · Phoenixville, PAN8357AMcclellan Richard G · Poplar Grove, ILN8357BHarker James P · Blaine, MNN8357KBaldasaro Bonnie B · Clifton Park, NYN8357MPrinceton Soaring Assoc · Princeton, NJN8358JMorrow John E · Clarendon, TXN8358LOc Flight Lessons LLC · Costa Mesa, CAN8358SStewart Bryan P · Carson City, NVN8358TTbs Aviation LLC · Wilmington, DEN8358UN8358u LLC · Knoxville, IAN8359AWoosley Kenneth D · Rumsey, KYN8359JManchester Eric S · Milton, VTN8359LBay Lux Ventures LLC · Tampa, FLN8359TCornejo Bernard J · Elko, NVN8359UMusgrove Stacy J · Cunningham, TXN835CPCivil Air Patrol · Maxwell Afb, ALN835EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN835FGRidgeline Assers LLC · Wilmington, DEN835KSKansas State University · Salina, KSN835MDMacconnell John · Deland, FLN835TAHuber Gary · Bradenton, FLN8360MOld Goat Aviation LLC · Naples, FLN8360QU S Department Of The Interior · Boise, IDN8360UHead Joseph · Fairbanks, AKN8360XJk Sparks Inc · Lutz, FLN8361ABenton Paul N · Manhattan, KSN8361BBrim Robert H · Bellingham, WAN8361JCoughlin Kevin P · Ridge, NYN8361LMolid Robert J · Dubuque, IAN8361UBoss Gary W · Bronston, KYN8361ZVining Eric · Lowell, ARN8362BDelp Ryan K · Southbury, CTN8362UJohnson Scott T · Delta, UTN8362XMarlow Haley C · Carrollton, MSN8362ZCampbell Tyler A · Billings, MTN8363MWeatherford Ranches Support Services LLC · Arlington, ORN8363SHellie Andrew Bryant · College Place, WA
Back to AD 79-10-14 R1