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.

N2224J24j LLC · Driggs, IDBuilt 1966 · S/N 15065424N2224XRegistered aircraftBuilt 1965 · S/N 337-0124N22250Rush Christopher C · Anchorage, AKBuilt 1967 · S/N 15068167N22251Barber Michael L · Igo, CABuilt 1967 · S/N 15068168N22252Heid Nathan E · Nevada, OHBuilt 1967 · S/N 15068169N22253Blue Sky Investments LLC · Fayetteville, NCBuilt 1967 · S/N 15068170N22255Rodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 15068172N2225EQuad City Area Flying Eagles Inc · Milan, ILS/N 18260377N2225TBunger Richard E · Spring Branch, TXBuilt 1977 · S/N R18200001N22260Arnold James R · Latrobe, PABuilt 1967 · S/N 15068174N2226SE S P Aviation LLC · Wilmington, DEBuilt 1976 · S/N 21061171N2226YRamjattan Enarl A · Harahan, LABuilt 1967 · S/N 17700026N22271Ps N22271 LLC · Green Bay, WIBuilt 1974 · S/N 17264061N22276Ramsey Lenny J · Greeneville, TNBuilt 1968 · S/N 15068185N22277Gage Rodney L · Oak Grove, ARS/N 15068186N2227YAdam Lewis W · Chiefland, FLBuilt 1967 · S/N 17700027N22284Fenton Ted P · Rushville, MOS/N 15068191N22285Barlow Richard B · Stockbridge, GABuilt 1968 · S/N 15068192N2228GHalo Halo LLC · Milwaukie, ORS/N 51528N2228SHannaford Edward M · Roseville, MIBuilt 1976 · S/N 21061173N22297Trissell Flying Service Inc. · Clarksville, TXBuilt 1968 · S/N 15068199N2229CYleski LLC · Bozeman, MTBuilt 1953 · S/N 30529N2229ESix Pack Aviation LLC · Pocono Pines, PABuilt 1978 · S/N 17271193N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174N2229XByers Gary F · Wasilla, AKBuilt 1969 · S/N 185-1509N222AKChambers Samuel S · Salmon, IDBuilt 1953 · S/N 30097N222ATSierra 1 Tech Inc · Blue Jay, CABuilt 1968 · S/N 21059098N222AWJust Planes Inc · Hobbs, NMFirst renewal noticeBuilt 1969 · S/N 310P-0106N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264N222BKDeralex Airways LLC · Miami, FLS/N 17272887N222BVBb Air LLC · Chesapeake, VABuilt 1975 · S/N 17264997N222CTMorency Richard · Houston, TXBuilt 1974 · S/N 18263068N222ERGjg Air LLC · Amarillo, TXBuilt 1975 · S/N 18263978N222ETValiair Lc Trustee · Casper, WYBuilt 1981 · S/N P21000626N222FDKent State University · Stow, OHBuilt 1968 · S/N 15068498N222FFReagan John · Knippa, TXS/N 18253725N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191N222HPHarrison Walter E · Taylor, TXBuilt 1982 · S/N R18201881N222JHRegistered aircraftBuilt 1974 · S/N 18263066N222LJDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 33701764N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751N222MHJones Jimmy N · Bremond, TXBuilt 1972 · S/N U20601931N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473N222PAFrank Eric A · East Troy, WIBuilt 1976 · S/N 15078669N222PEPacific Air Charters Inc · Honolulu, HIBuilt 1976 · S/N 310R0632N222PFStokes Brian L · Boulder City, NVBuilt 1979 · S/N R18201308N222PLAnderas Per R · Green Bay, WIS/N 414A0521N222PRFlying South LLC · Wilmington, DEBuilt 1973 · S/N 4140384
Back to AD 97-01-13