AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N17230Chase Melissa L · Port Orange, FLN1723QScroggy Edward R · Louisville, KYN1724FWalters Todd J · Darwin, MNN1724NTurcott Joshua A · Stockton, CAN17251Aurora 17 Holdings LLC · Aurora, ORN17256Smith Taylor C · Amarillo, TXN17257Johnson Ralph R · Roanoke Rapids, NCN17258Registered aircraftN1725DBeisheim Carrie E · Fort Calhoun, NEN1725FWagner Harold D Jr · Hilltop Lakes, TXN17260Woodley Aerial Leasing LLC · Walnut, ILN17263Medbery Nathan J · Minto, NDN17267Munch James L · Aumsville, ORN1726NGranneman William L · Costa Mesa, CAN1726VBosquet Arthur · Highgate Center, VTN1727DHall L Robert · La Verne, CAN1727FWhetham Ed · Wilton, NDN1727QGlobal Flight Training Solutions Inc · Immokalee, FLN1728FLemmon Mark D · Heppner, ORN1728KNauta Gordon W · Palmdale, CAN1728QUnd Aerospace Foundation · Grand Forks, NDN1728VMoore Edward L · Hixson, TNN17291Region Flyers LLC · Valparaiso, INN17293Kieren Bryce J · Tucson, AZN17295Alaverdi Omeed · California, MDN17298Biller Luke A · Milton, DEN17299Sale Reported · Mobile, ALSale reportedN172APocock Milne David · Cal Nev Ari, NVN172AKGazarek Edward · Fort Myers, FLN172BBGlabe David Kristopher · La Grande, ORN172BCSlayton Jeffrey W · Prospect, TNN172BHWright Charles L · Kirkland, WAN172BNRedtail Aviation LLC · Rexburg, IDN172BXBas Part Sales LLC · Greeley, CON172CFMontagne Denise A Trustee · Reno, NVN172DFMajercik Donald A · Jericho, VTN172DKVertikle Enterprises LLC · Cheyenne, WYN172DTMilam Six LLC · Milam, TXN172EGMondloch Jesse R · Freedom, WIN172FDoig Richard M · Walton, NYN172GFDel Martin Lp · Spring, TXFirst renewal noticeN172GLGlover Anthony R · Louisville, KYN172GVJackson Gordon W · Fort Worth, TXN172GXSingleton Randy V · Shippensburg, PAN172HMatusky Gregory S · Cal Nev Ari, NVN172JAPalmenteri Louis J · Rhome, TXN172JKHillman Aviation LLC · Bossier City, LAN172JNRedd Charles · Dutton, MTN172JTLiberty Zone LLC · Wilmington, DEN172KCWellner Thomas B · Bremerton, WA
Back to AD 94-05-05 R1