OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N720WCSw Aviation LLC · Wilmington, DEBuilt 1991 · S/N TH 1624N721Department Of The Interior · Boise, IDBuilt 1981 · S/N U20606256N72106Dahl George Robert · Bethel, AKBuilt 1969 · S/N U206-1282N72117Ott Steve G · Reedpoint, MTBuilt 1969 · S/N U206-1286N72124Fuller Kenneth C · Studio City, CABuilt 1984 · S/N CE-1047N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207N72160Mccauley Thomas I · Puyallup, WAS/N U206-1303N7218HBoston Robert G · Atlanta, GABuilt 1985 · S/N CE-1056N7218RCourtney James Trustee · Menlo Park, CABuilt 1974 · S/N E-616N7218SRegistered aircraftBuilt 1984 · S/N CE-1051N72194Skydive Ky LLC · Cecilia, KYBuilt 1969 · S/N U206-1315N7219CDesigns International Inc · Johnston, RIBuilt 1984 · S/N CE-1052N7219UHolt Daniel E Jr · Fayetteville, TNBuilt 1984 · S/N CE-1053N721CGJohnson Charles G · Jackson, MSBuilt 1966 · S/N CE-86N721CVDvf Ventures LLC · Alapaha, GABuilt 2004 · S/N TH-2078N721DGDtt Holdings LLC · Kalispell, MTBuilt 2008 · S/N E-3878N721DKRegistration Pending · Fountain Hills, AZRegistration pendingBuilt 1997 · S/N E-3123N721EBBiggs Aircraft Inc · Wellston, OKBuilt 1966 · S/N CE-66N721ENCmjd Aviation LLC · Marion, ILBuilt 2008 · S/N E3848N721JPTkw Properties & Investments LLC · St Simons Island, GABuilt 2002 · S/N E-3470N721LTWhite River Holdings LLC · Southaven, MSBuilt 1983 · S/N TH-1387N721NRUS Department Of The Interior · Boise, IDBuilt 1985 · S/N U20606902N721PGKelly Site Development LLC · Durham, NCS/N 29-0120N721RSStill Charles · Fountain Valley, CABuilt 1966 · S/N D-8086N721SGAlaska Air Service LLC · Brookings, ORBuilt 1964 · S/N 206-0265N721VCSch Aviation Inc Trustee · SporleBuilt 2002 · S/N 0361N721VGB & W Aerial Spray Inc · Dimmitt, TXS/N 421B0847N721WTop Flight Aviation LLC · Kingfisher, OKBuilt 1972 · S/N D-9361N721WMSoftcomm Aviation Inc · Irvine, CABuilt 1995 · S/N 29-0023N721YGRunway Aviation Flight Training USA Corp · Rockwall, TXBuilt 1974 · S/N 340-0342N7220JMuddy Waters LLC · Pompano Beach, FLBuilt 1984 · S/N TH-1449N72222Jouppi Kenneth J · Ward Cove, AKBuilt 1969 · S/N U206-1329N7222H7222h LLC · Catlett, VABuilt 1984 · S/N E-2179N7222LAllmon William C · Las Vegas, NVFirst renewal noticeS/N TJ-484N7222NN B Tweet & Sons · Nome, AKBuilt 1976 · S/N U20603568N7223BAmerican National University Inc · Salem, VABuilt 1985 · S/N TH-1443N7224LRussell Jerald Trustee · Pampa, TXBuilt 1985 · S/N CE-1057N7225HCosmo Plastics Company · Pepper Pike, OHBuilt 1985 · S/N TJ-485N7225MPeterson Bernard L · Bardstown, KYBuilt 1985 · S/N E-2282N7225RWalker Michael E · Lewistown, MTBuilt 1974 · S/N TH-550N7226KAgile Aviation LLC · Hilliard, OHBuilt 1985 · S/N CE-1058N72285Cave Creek Organics LLC · Flagstaff, AZBuilt 1969 · S/N U206-1351N72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeBuilt 1969 · S/N U206-1353N72291Wandering Quarks LLC · Lincolnville, MEBuilt 1985 · S/N E-2247N72299Johnson James C · Marion, KYBuilt 1985 · S/N CE-1061N7229XH&H Aviation Inc · Port Orange, FLBuilt 1985 · S/N CE-1063N722AGLdg Aviation LLC · Carefree, AZFirst renewal noticeBuilt 1977 · S/N TH-799N722BGrabiel Don J · Alpena, MIBuilt 2005 · S/N ES-128N722BJBravo Juliett LLC · Bermuda Run, NCBuilt 2004 · S/N 1043N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332
Back to AD 86-13-04 R3