OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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

N2024VWhiskey Tango Flyers Inc · Middletown, DEBuilt 1978 · S/N D-10165N2024WMunn Jeffrey R · Auburn, NYBuilt 1966 · S/N D-8078N2024XMahaney Nicholas · Tahlequah, OKBuilt 1965 · S/N 18256124N20252Morino William D · Palos Verdes Est, CABuilt 1981 · S/N 18053183N2025NA B C Leasing Inc · Oakdale, LABuilt 1978 · S/N E-1336N2026WGta Air Inc · Addison, TXBuilt 1978 · S/N TH-976N2026XGonzales Alvin S · Mount Prospect, ILBuilt 1965 · S/N 18256126N2027DNichols Neil A · Aalachicola, FLBuilt 1978 · S/N TH-974N2027GCloudsight LLC · Surfside, FLBuilt 1958 · S/N 51327N2027RSinko James W · Menlo Park, CABuilt 1964 · S/N 18255227N2027UJpb Diversified LLC · Auburndale, FLBuilt 1978 · S/N TH-964N2027WMckinney Karen L · Naperville, ILS/N CD-976N2027XArchuleta Tommy L Jr · Bermuda Dunes, CABuilt 1965 · S/N 18256127N2028AWallender Timothy J · Manhattan Beach, CABuilt 1969 · S/N D-9026N2028PFerm Michael D · Fort Calhoun, NEBuilt 1978 · S/N D-10167N2028SScherler Burl M · Sheridan Lake, COBuilt 1975 · S/N 21060996N2028WN2028w LLC · Oakdale, CABuilt 1966 · S/N TE-87N2028XWalker James H III · Anderson, SCBuilt 1965 · S/N 18256128N20292Laflight LLC · Goldsboro, NCBuilt 1978 · S/N TH-966N2029DVictory Auto Sales LLC · Memphis, TNFirst renewal noticeBuilt 1978 · S/N D-10168N2029GHendry Jeremiah D · Aurora, ILS/N 51329N2029PTurnpoints LLC · Wilmington, DEBuilt 1978 · S/N E-1346N2029RSoardro Ltd · Wilmington, DEBuilt 1964 · S/N 18255229N2029SCanyon West LLC · Amarillo, TXFirst renewal noticeBuilt 1975 · S/N 21060997N2029WWilliams Steve C · Elgin, SCBuilt 1966 · S/N CD-978N202ARicky B'S Aviation Inc · Wilmington, DEBuilt 1966 · S/N 68-11157N202AFWhite James R · West Liberty, OHBuilt 1969 · S/N 68-10862N202BHarper Aviation LLC · Arlington, TXBuilt 2025 · S/N 10730N202BCTff Inc · Parma, MIBuilt 1957 · S/N D-5199N202CMCambridge LLC · New Cumberland, PABuilt 2005 · S/N 1684N202DKAuto Key Masters And Locksmith LLC · Watts, OKBuilt 1978 · S/N TC2152N202EPSonnenberg Jerry · Sterling, COBuilt 1980 · S/N 18267673N202FWeiherer Jeffrey Paul · Thousand Oaks, CABuilt 1957 · S/N 34011N202FDPro Ag Aviation LLC · Luverne, MNBuilt 2025 · S/N 10394N202JRiche Aviation LLC · Baton Rouge, LABuilt 1964 · S/N D-7418N202JTHour Time Machine LLC · Bloomington, INBuilt 2002 · S/N 0230N202MDHay Pile Aviation LLC · Gilbert, AZBuilt 1966 · S/N TE-148N202PSc Infinities LLC · Dover, DEBuilt 1998 · S/N TH-1875N202SMyers Jon D · Montrose, COBuilt 1956 · S/N 32355N202SASnider Bruce E · Mckinney, TXBuilt 1968 · S/N 18259082N202SRCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11394N202SWMar Jar LLC · Gilmer, TXFirst renewal noticeBuilt 1980 · S/N 414A0515N202WFPro Express LLC · Alliance, NEBuilt 1978 · S/N 28R7803325N20307N20307 LLC · Trabuco Canyon, CABuilt 1978 · S/N D-10174N2030KBuck William C Jr · Columbus, GABuilt 1978 · S/N E-1358N20315Drago Air LLC · Mulberry, INBuilt 1981 · S/N 18053184N20318Siegfried Thelma Trustee · Downers Grove, ILBuilt 1978 · S/N D-10173N2031BHouser Roger · Luray, VABuilt 1978 · S/N E-1350N2031KObrien Michael · South Orleans, MABuilt 1978 · S/N E-1352N2031PBrooks Todd P · White Lake, MIBuilt 1978 · S/N E-1349
Back to AD 2000-23-21