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.
N7440QAircraft Holding LLC · Orem, UTN7440TFranklin Benjamin L Jr · Woodstock, GAN7440XWatonwan Flyers Inc · Saint James, MNN7441AMadison Nicholas R · Fayette, ALN7441GSussex Aero Maintenance Inc · Georgetown, DEN7441NAir Impressions Inc · Waco, TXN7441QSelinger Melvin · Arcata, CAN7441TGarst Lynn F · Oklahoma City, OKN7441XHolland Newel G · Nacogdoches, TXN7442TTrono Zach C · Charlotte, VTN7442XBeail Herschel D · Quincy, CAN7443MVaccari Kevin N · Walnut Ridge, ARN7443TGuarno Adam C · Milton, FLN7444MMitchell Lester L · Okmulgee, OKN7444QGroffman Armand Rossini · Los Alamos, NMN7444TDmac Aircraft LLC · Savannah, GAN7445EElite Aircraft Sales LLC · Searcy, ARFirst renewal noticeN7445NSkyplane Pilots LLC · Bluffton, SCN7445QPennino James B · Rancho Cucamonga, CAN7445TKiss Sandor A Jr · Petaluma, CAN7445XMelott Matthew · Mesa, AZN7446MHobson George A · Fairbanks, AKN7446QAvco Patrol LLC · Lyndon, KSN7446TGot Wings LLC · Woodbury, NYN7447XBrewer Eric V · Alva, OKN7448MCadwell David Earl · Windsor, CON7448NCcx-2000-0111 LLC · Garberville, CAN7448QWilkus Michael J · Mound, MNN7448XPeterson Bruce L · Williston, NDN7449EDabir-Ebrahimi Mike M · San Mateo, CAN7449GAvmajic LLC · Waterford, MIN744CPCivil Air Patrol · Maxwell Afb, ALN744DPAviation Components Inc · Tarzana, CAN744EFTango Alpha Sierra LLC · Austin, TXN744MDeforest Shawn L · Lexington, NCN744NGEvans William H Jr · Gardendale, TXN744RCastaneda Jose · Yakima, WAN744TAAtp Aircraft 7 LLC · Wilmington, DEN744WTwin Bridges Aviation LLC · Sheridan, MTN7450EFernald Greg · New River, AZN7450GLewis Benjamin · Delano, MNN7450MJones Jeremy · Lampasas, TXN7451ETucker Charles M · White City, ORN7451GPresto William R · Houston, PAN7451XReady Aim Flyer LLC · New Castle, DEN7452AHill Nathaniel J · Goldendale, WAN7453ASwope Aviation Solutions LLC · Independence, MON7453EMuller Ronald V · Kansas City, MON7453GNorthwoods Flyer LLC · Jacksonville, FLN7453MHauser Casey L · Springfield, OR
Back to AD 79-10-14 R1