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.
N77DHBramon Bruce M · Sunrise Beach, MON77DNGrant County Mosquito Dist #1 · Moses Lake, WAN77ERFrech Betty J Trustee · Columbia, MON77ESRegistered aircraftN77FWBrooks Dylan · Anchorage, AKN77GZImpact 4 Christ Ministries · Crescent City, CAN77JFWilliams Mike C · Sonora, TXN77JPDakota Aircraft Inc · Pierre, SDN77KBBears Tooth Resources LLC · Red Lodge, MTN77LARaintree Aviation LLC · Mesa, AZN77LCWright Aviation LLC · Sugar Land, TXN77LUGerman Farms Inc · Fullerton, NDN77PPBloom Jonah M · Palmer, AKN77RASky West Aviation Inc Trustee · Albuquerque, NMN77RBBeckham William R · Cumming, GAN77SYOlson Michael A · Londonderry, VTN77TASword Gary · Greenville, TXN77TDBeavin Robert A · Wilton Manors, FLN77VMBadger Ray · Baker City, ORN77WSRegistered aircraftN77XDTrost Aviation LLC · Fishers, INN77XPObrien Daniel T · Boise, IDN7800EWings Unlimited Inc · Loup City, NEN7800FS & L Aviation LLC · Ashland, OHN7800GSale Reported · Roseville, MNSale reported, pending cancellationN7800KMadero Albert A Sr · Grass Valley, CAN7800TNorth Texas Aeronautics LLC · Burleson, TXN7800URipplinger Max · Santa Clara, UTN7801ENorman Dennis E · Bothell, WAN7801KBurley Richard A · Fairbanks, AKN7801UDeli Rick L · Oshkosh, WIN7801XHuckins Randall A · Goddard, KSN7801ZRegistered aircraftN78027Cramlet Kirk T · Woodlake, CAN7802FHuntting Preston I · Camp Verde, AZN7802KMagliacano Metal Worx Inc · La Cygne, KSN7802XDykstra Wayne A · Pipestone, MNN7803GTomlin Jonathan S · Georgetown, OHN7803KBales Ranch Inc · Otter, MTN7803UBishop John D · Phoenix, AZN7804GWells Adam · New Lexington, OHN7804ZRegistered aircraftN7805AJohnson Todd M · Hudson, WIN7805GArgabright John · Waterford, OHN7805TSanford William M · Olalla, WAN78066Orlandi Properties LLC · Blairstown, NJN7806AFullerton Paul S · St Ignace, MIN7806FTaheri Jay · Ridgewood, NJN7806GAircraft Management Services Inc · Milton, FLN7806KWilson David J · Palmer, AK
Back to AD 79-10-14 R1