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.
N782WWDraco Flight School DBA · Chino, CAN78302Gardner Christopher · South Saint Paul, MNN78303Citizen Air LLC · Port Angeles, WAN78305Woollen Claude D · Moore, SCN7830GSkildum&Company LLC · Grand Marais, MNN7830KColberg Sigurd E · Palmer, AKN7830TWalker Homes LLC · Stratford, OKN7830UObrien Cornelius R · Sellersville, PAN7830ZFlanary Kenneth Mitchell · Five Points, ALN78312Roemer Joanne · Kemah, TXN7831FHallmark Ryan M · Vidor, TXN7831UHerrin Thomas · Patterson, GAN7831XChupka Kris W · Golden, CON7832TN7832t LLC · Wilmington, DEN7832UFly 32u LLC · Monroe, NCN7832ZArnold Mark D · Holloway, MNN78330Wings Over Texas Holdings LLC · Denton, TXN78331Clifton Jack D · La Junta, CON78332Albright John T · Decatur, ALN78335Marotte David J · Windham, NHN78338Mbh Aviation LLC · Tulalip, WAN78339Hopfmann Alwin E · Rutland, MAN7833EChecky Allan O Jr · Merrimac, WIN7833GOrlandi Properties LLC · Blairstown, NJN7833MFoote Lori A · Decherd, TNN7833TJohnson Spring M · Wortham, TXN7833ULfs Inc · Gillette, WYN78340Mcclellen Andrew C · Dallas, TXN78341Davis Glenn A · Fair Oaks, CAN78349Raker Theodore B · Hahira, GAN7834GSmith Perry L · Brook Park, MNN7834KSautner Steve · Anchorage, AKN7834TYturri David P · Marble Falls, TXN7834USirens Call LLC · Nashville, TNN7834ZRall Jared W · Williamsport, PAN78351Caron John · Ellsworth, MIN78354Tonar Richard J Jr · Omaha, NEN78355Fleming Gary R · Wickliffe, KYN78358All American Aviation LLC · Fort Worth, TXN78359Burns Stanley R · Flagler, CON7835EUnternaehrer Robert U Trustee · Brunswick, MON7835MTimpauer Alberto N · Mesa, AZN7835TRound Engine Aero · Nashville, MIN7835UEyrie Aviation LLC · Suwanee, GAFirst renewal noticeN78367Dardis Barry J · Great Falls, MTN7836KKennedy Brent Robert · Anchorage, AKN7836XOsage Aviation LLC · Yates Center, KSN7836ZSpartan National Holdings LLC · Missoula, MTN78371Lillace Kevan · Shelby, MTN78375Bozeman Leasing Inc · Bozeman, MT
Back to AD 79-10-14 R1