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.
N5829AVine Clayton A · Wolf Point, MTN5829BFair Skies Inc · Dade City, FLN5829FMoa Klinton J · Bellingham, WAN582LPCape Island Aviation LLC · Millville, NJN582SPSvanberg Craig Emile · Dayt Bch Sh, FLN582TCBreak For It Aviation LLC · Draper, UTN58302Gillett John W · Hillsboro, ORN5830AChapman Erin A · Edmond, OKN5830BHaberich Alexander J · Avon, CON5830FSuchy Karel · Kenosha, WIN5830GDunn Michael J · Ozark, ARN5830JMontague Brett A · Van Buren, OHN58316Labelle-Hamer Brendan T · Fairbanks, AKN5831ECampbell Jennings R · Bell, FLN5832ABurgess Kelly M · Dannebrog, NEN5832BAircraft Structural Repair Inc · Hamilton, MTN5832GFitzgibbon Patrick D · Waterloo, WIN5832JAerial Advertising Services · Livermore, CAN5833AJones Curtis DBA · Jacksonville, NCN5833FVermillion Fc-1 LLC · Crystal City, TXN5833JAlbatross Air Inc · Beaver, WVN5834EKendall Samuel · Fairbanks, AKN5835ABoyd Edward L · Riverton, ILN5835BJepson Duwayne D · Frazee, MNN5835ELaw Brian W · Brodhead, WIN5836AMallach Kenneth L · Gatesville, TXFirst renewal noticeN5836ESchulz Michael A · Upland, CAN5836JMeyerkorth Aviation LLC · Rock Port, MON5837ACrawford Mike R · Flowery Branch, GAN5839BReffett John S · Eagle River, AKN5840ETnw Aviation LLC · Clinton, ARN5841ASeipel Damian Y · Huntington Beach, CAN5841BFultz Wilbur R · Fort Benton, MTN5841GCrawford Trevor Nicolas · Potter Valley, CAN5842BPietrs Michael · Shoreview, MNN5842FHci Properties LLC · Frankston, TXN5842TArapaho Air LLC · Walnut Grove, CAN5843EMedlin Wayne D · Marshville, NCFirst renewal noticeN5843FU3 Aviation LLC · Little Rock, ARN58441Tall Timber Flying Service LLC · Kalispell, MTN58442Van Vleet Dennis · Kingman, AZN58443Szeliga Mark H · Bethel, MEN5844GLummus David R · West Point, MSN58454Thiele John E · Harrison, IDN58457Registered aircraftN58458Prairie Wings Aviation LLC · Victoria, TXN5845GBerg William J · Aberdeen, SDN58465Ram Air LLC · Portland, MEN58466Aerial Transport LLC · Dover, DEN58467Schaefer Leonard · Oak Dale, PA
Back to AD 79-10-14 R1