OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,131

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:2009-13-06-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:2009-13-06-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.

N396FWRoute 66 Aerostars LLC · Galena, KSBuilt 1980 · S/N 428001021N396JHGoode Todd · Nampa, IDS/N 31T-7920087N398SPHillcrest Aviation LLC · Clear Lake, IAS/N 31T-8104027N39CACannondale Aviation L L C · Wilton, CTS/N 31-8212030N39EHAir Travel Management Of Delaware LLC · Wilmington, DEBuilt 1978 · S/N 31T-7920020N39HASmc Ltd · Somerset, WIS/N 31-497N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943N39TLDunamis Resources LLC · Lewes, DES/N 31T-8104012N3RKCorinthian LLC · Southgate, MIS/N 31T-8166022N3SPAvon Aero Supply Inc · Orlando, FLBuilt 1984 · S/N 42-5527018N3UGHoffman William C · Mount Pleasant, PABuilt 1977 · S/N 27-7854050N3VMAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1973 · S/N 31-7305069N4008PViento LLC · Nashville, TNS/N 23-1483N4009PApplegate Ronald E · Rosamond, CABuilt 1958 · S/N 23-1484N400CMAerial Surveys International LLC · Watkins, COBuilt 1976 · S/N 31T-7620040N400ELEmmair LLC · Greenbrier, ARBuilt 1989 · S/N 42-5527041N400HMBarneys Services Inc · Newton, IABuilt 1979 · S/N 31-8052030N400LRKelly Aero LLC · Montgomery, ALBuilt 1984 · S/N 42-5527003N400MJHaney Michael W · Tehachapi, CAS/N 23-1627N400PBPlane Easy LLC · Lake Worth, FLBuilt 1984 · S/N 425527005N400RAJacko Josh E · Anchorage, AKBuilt 1974 · S/N 31-7405167N400VBKelleher Corporation · San Rafael, CABuilt 1985 · S/N 42-5527002N400WSHatbright Farm LLC · Wilmington, DEBuilt 1981 · S/N 31T-8166044N4011PWelke Paul R · Beaver Island, MIBuilt 1958 · S/N 23-1486N4014PGriffing Flying Service Inc · Port Clinton, OHBuilt 1958 · S/N 23-1489N4017P17p LLC · Caddo Mills, TXS/N 23-1492N401JTN401jt LLC · Denver, COS/N 42-5501023N401MBFly Aztecs LLC · Waterloo, NEBuilt 1977 · S/N 27-7854013N401PJSkylens LLC · Hammond, LABuilt 1968 · S/N 27-4112N401VAPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1982 · S/N 31T-8275001N40200Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 27-7304997N4023Maighnath Melissa · Jamaica, NYS/N 31-8152067N40254Jezior Michael · Midland, MIBuilt 1973 · S/N 27-7305061N40267Island Birds Inc · St Thomas, VIBuilt 1973 · S/N 27-7305080N40279Hhozapnv LLC · Las Vegas, NVBuilt 1973 · S/N 27-7305093N4027PAg Air Squadron One LLC · Saint Joseph, ILBuilt 1958 · S/N 23-1502N40288Pacific Fleet Aviation LLC · Rochester, NYBuilt 1973 · S/N 27-7305104N4032PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1508N4034PKoenig William J · Benedict, MDS/N 23-1510N4036PFiegel Donald H · Ward, ARBuilt 1958 · S/N 23-1512N40372Gajewski Lillia M · Billings, MTBuilt 1973 · S/N 27-7305135N40399Aviation Academy LLC · Wichita, KSBuilt 1973 · S/N 27-7305163N4039PPetersen Clayton L · Albert Lea, MNBuilt 1958 · S/N 23-1516N403MCorporate Aircraft Group LLC · Annapolis, MDS/N 31T-8004033N403RGGkids Holdings LLC · New York, NYS/N 31-7952219N40400R & P Aero LLC · Grand Haven, MIBuilt 1973 · S/N 27-7305164N4042MLinville Air LLC · Denver, NCBuilt 1980 · S/N 31-8112014N4043MPremier Air Charters Inc · Coram, NYBuilt 1980 · S/N 31-8152001N40453Aerospace Trust Management LLC Trustee · Wilmington, DES/N 27-7305166N40454Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 27-7305167
Back to AD 2009-13-06 R1