OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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-01-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:97-01-01-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.

N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558N921JBC&Z Aero LLC · Des Plaines, ILBuilt 1976 · S/N 32R-7780099N921LJGossett Chase · Centre, ALBuilt 1977 · S/N 32R-7780449N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721N9225PRegistered aircraftBuilt 1967 · S/N 24-4722N9226KAlatis Nicholas C · Cincinnati, OHBuilt 1976 · S/N 32R-7680199N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717N9228FWard Jack R · Simi Valley, CAS/N 32R7680197N9228PShillig Vance R · Colorado Springs, COS/N 24-4726N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734N9236CRudloff Uwe K · Lake Village, INBuilt 1978 · S/N 28R-7837181N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736N9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627N924JCCroman Graham P · Clayton, GAFirst renewal noticeBuilt 1977 · S/N 28R-7703196N924RRHigh Timothy Duane · Glenwood, MOBuilt 1977 · S/N 32R-7780450N924SMRed Rock Flying School LLC · Mesa, AZBuilt 1976 · S/N 32R-7680090N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747N9251PSalori Aviation LLC · Centralia, MOBuilt 1967 · S/N 24-4749N9252POsipov Yuri A · Lomita, CABuilt 1967 · S/N 24-4750N9253PConway Brandon · Springtown, TXBuilt 1967 · S/N 24-4751N9254PMeyer Aviation LLC · South St Paul, MNBuilt 1968 · S/N 24-4752N9255PSalvia Michael · Farmington Hills, MIBuilt 1968 · S/N 24-4754N9258PCessna 79432 LLC · Missoula, MTBuilt 1968 · S/N 24-4757N9259PChiarini Joshua · Cranston, RIBuilt 1968 · S/N 24-4758N925DGNwi Drones LLC · Chesterton, INBuilt 1960 · S/N 24-1870N92605Sarratt Curtis H · Annapolis, MDS/N 2844002N9262CRick Aviation Inc · Newport News, VABuilt 1978 · S/N 28R-7837183N9262PReliant Aeroworks LLC · Sanger, TXBuilt 1968 · S/N 24-4761N9263KCrook Michael J · Paradise, UTBuilt 1976 · S/N 32R-7680205N9263PWhitacre John B III · Waynesburg, OHBuilt 1968 · S/N 24-4762N9264PBeil Richard P Trustee · Caroline, WIBuilt 1968 · S/N 24-4763N9266KRestrepo Aircraft Corp · Fort Lauderdale, FLBuilt 1996 · S/N 2844004N9267PNickravesh Niknam J · San Jose, CABuilt 1968 · S/N 24-4767N9268PAts Inc · Chicago, ILBuilt 1968 · S/N 24-4768N9269PRegistered aircraftBuilt 1968 · S/N 24-4769N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770
Back to AD 97-01-01 R1