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.
N493RMRaritan Valley Flying School · Princeton, NJN493SHForsman David G Co-Trustee · South Haven, MNN493WCOsness Rhonda R · Bisbee, NDN4940ASims Charles A · Chugiak, AKN4940DAirborne One LLC · Kalispell, MTN4940EFlyright Aviation Inc · North Las Vegas, NVN4940GN4940g LLC · Portsmouth, NHN4940NWray James R Jr · Brighton, CON4941FPaddock Levi · Springfield, ORN4942AChapman Peter E · Placerville, CAN4942DN4942d LLC · Greenfield, NHN4942UCenturion LLC · Bonney Lake, WAN4943EPettit Robert · Carnegie, OKN4944DSelkirk Associates Inc · Wilmington, DEN4944PReed John Richard · Charleston, ILN4944RRoma Air Corp · Belle Glade, FLN4945AIverson Randy · Winnemucca, NVN4946ESallmon Helga R · Sandpoint, IDFirst renewal noticeN4947AGleiter David W · Overland Park, KSN4947DEnstrom Thomas · New Berlin, NYN4947GRiya Aviation LLC · Tracy, CAN4947QDavison Aviation LLC · Garnett, KSN4948CRobillard Ross · Eveleth, MNN4948DSobrado Victor M · Norman, OKN4948GTrece Inc · Adair, OKN4948QWhite Ronald A · Anchorage, AKN4948RBlain Monte W · Joliet, MTN4948URegistered aircraftN4949ETrans Crafts LLC · Big Lake, AKN4949GFalcon Aviation LLC · South Saint Paul, MNN4949NCompass Rose Aviation · Derby, KSN4949RValley Flying Service Inc · Orleans, NEN494AMOsprey Holding Company LLC · Foley, ALN494EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN494JBD & S Aviation LLC · Spring, TXN494PCChristensen Darrel W Jr · Soldotna, AKN494RAAstra Integrated Technologies LLC · Rockledge, FLN494SPInternational Air Services Inc Trustee · Carson City, NVN494TMDuke Flight Training LLC · Bonnyman, KYN494WAFly More Inc · Kawkawlin, MIN4950DSimpson Darrell W · Soldotna, AKN4950HVaivadas Brian S · Bonney Lake, WAN4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALN4950UAerotech Mapping Inc · Las Vegas, NVN4950ZRiverside Tractor Inc · Friendswood, TXN4951FAerial Services Inc · Cedar Falls, IAN4951GMelbourne Flight Training LLC · Melbourne, FLN4951NCactus Av8rs LLC · Gilbert, AZN4951YH & B Aeronautics LLC · Miamisburg, OHN4952EHess Michael D · Wasilla, AK
Back to AD 79-10-14 R1