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.
N300Texas Sky Masters Inc DBA · Dallas, TXN3000QFlying H Enterprises · Santa Fe, NMN3000TN3000t LLC · Townsend, GAN3000UMerrell Warren W · Idalou, TXN3000YChesebro Ben D · Tucson, AZN30013Patton Mark E · Dryden, NYN30014Tri-State Aviators LLC · Ironton, OHN30017Landon Kasiri · Lancaster, CAN3001UPrairie Flyers · Rocky Ford, CON3002QJaeger Christopher E · Normandy Park, WAN3002YGiefer Brett T · Nicollet, MNN30033Mission Aviation Training Academy · Arlington, WAN3003ETuskegee Airmen National Historical Museum · Detroit, MIN3003FHassinger Farms LLC · Cove, ORN3003JCoastal Valley Aviation · Santa Maria, CAN3003XAero Flyers LLC · Stephenson, VAN30040Schaller Neil J · New Athens, ILN30043Singer Mark D · Stafford, VAN30044Air Data Solutions LLC · Natchitoches, LAN3004FN3004f LLC · Cranberry Township, PAN3005FE & E Jones Farms LLC · Munford, ALN3005SSpennato Peter Jr · Rolling Hills, CAN3005XOso Air LLC · Missoula, MTN30064Avarix Inc · Cool, CAN3006QHarrington Michael L · Twin Falls, IDN3006SGrice Warren A · Marshall, ARN3006XRegistration Pending · Scottsdale, AZRegistration pendingN3006YWissner Martin L · Carpenter, WYN3007FTroelstra Frederick D · Queensbury, NYN3007XKelley Keith B · Forney, TXN3008EShore Gerald E · Inez, TXN3008XAdams Harold L · Beaver, OHN3008YWidmier Kolby J · Price, UTN30096Sirek David G · Fritch, TXN30098Humbert Randy M · Tumtum, WAN3009SRegistration Pending · Arlington, TXRegistration pendingN3009XWarren Jeremy I · Horse Cave, KYN300BRMach Tuck Aero Group LLC · Elkhorn, NEN300BWWatson Brent J · Bountiful, UTN300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKN300DFDowner Justin W · Berthoud, CON300EB4031 Pilots LLC · Crown Point, INN300EJPartwin LLC · Greenwich, CTN300EMMark Thomas Productions LLC · Ketchum, IDN300EW2f Trade LLC · Collinsville, TXN300FDGondola Investments LLC · Miami, FLN300KBBailey Stephen M Trustee · Lawton, OKN300KTKarnowski Ventures LLC · Manhattan, KSN300KZDependable Aviation LLC · Cartersville, GAN300LCRobinson Russell J · Bridgeport, TX
Back to AD 97-01-13