AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N2991KHayton James B · Sedro Woolley, WAN2991SVanbrocklin Valerie A · Anchorage, AKN2991UNeary Joseph P · Lindenhurst, ILN2991XDewald David J · Fort Wayne, INN2991YRabska William G · Suisun City, CAN2992SN2992s LLC · Bristol, VTN2993CFrei Jayci N · Grangeville, IDN2993FDaniels Aviation Inc · Inverness, MSN2993SCintron Jaime · Lake City, FLN2993U63 Aviation LLC · Petoskey, MIN2993XKreutzer Charles · Springfield, ILN2993YBranch Robert W · Fort Mohave, AZN2994ADicicco Matthew Trustee · Los Gatos, CAN2994ESkyventure Aviation LLC · Battle Creek, MIN2994XBas Part Sales LLC · Greeley, CON2995FCj3 Aviation LLC · Idaho Falls, IDN2995SWillard Kevin C · Bartlett, NEN2996CSutton Aircraft Salvage LLC · Palmer, AKN2996FSmooth Air LLC · Mequon, WIN2996JDziadaszek Daniel J · Yemassee, SCN2996SKingdom Air Corp · Sutton, AKN2996XEagle Sky Patrol Inc · Deadwood, SDN2996YCrowe Timothy P · Gilbert, AZN29970Andrecheck Cynthia R · Bethel, AKN29972Windblown Ranch Inc · Echo, ORN2997CSmith Philip W · Copeland, KSN2997UWilliams Michael L · Skaneateles, NYN2997YSkyriders LLC · Flagstaff, AZN2998FChristian Halls International · Arlington, TXN2998KWallingsford Don C · Yorba Linda, CAN2998YReynolds Peter · Athol, MAN2999AFindly Raymond Lee · Ravenna, KYN2999CCarnine Daniel L · Seeley Lake, MTN2999SZheng Zheng · Walnut, CAN2999URichmor Aviation Inc · Hudson, NYN2999XPoore Zack W · Mcdonald, KSN299GBHoodoo LLC · Missoula, MTN299MPayne Michael Allen · Montgomery, TXN299MWAbramovich Michael Pavel · Scottsdale, AZN299PTWright W Gregory III · Kinsale, VAN299RQRds Aviation LLC · Powder Springs, GAN29ANSouth Aero Inc · Albuquerque, NMN29BCD' Jm Holdings LLC · Sugar Land, TXN29BEAltaii Ali · Gibraltar, MIN29CMChenango 11 LLC · Wilmington, DEN29ERCosta Air Service LLC · Painted Post, NYN29FCUsda Forest Service Fepp · Raleigh, NCN29FLTorres Chris · Princeton, CAN29HLSchreiber Christopher · Foley, ALN29JFJkg LLC · Murfreesboro, TN
Back to AD 97-01-13