OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N465JRegistered aircraftBuilt 2011 · S/N 0157N465KJBvw Aviation LLC · Grand Rapids, MIBuilt 2025 · S/N 10663N465PEHoyle Jason R · Grove, OKBuilt 1966 · S/N TE-112N465SAGilmore Air LLC · Boca Raton, FLBuilt 2002 · S/N E-3465N465TByrds Wholesale Inc · Clayton, NCS/N 18260715N465TXLsa Aircraft Holdings LLC · Houston, TXBuilt 2020 · S/N 2073N465TYBear Flight LLC · Atlanta, GABuilt 2026 · S/N 11494N4660AConnealy Air LLC · Whitman, NES/N 32257N4660BEllison Orlo T · Broomfield, COBuilt 1955 · S/N 31558N4660DSale Reported · Milwaukee, WISale reportedBuilt 1956 · S/N D-4885N4660JStuder Al C · Shelby, MIBuilt 1980 · S/N T18803759TN4660KFoster Gary Paul · Willow, AKS/N 18263662N4660NCasey Kellie M DBA · Fort Worth, TXBuilt 1979 · S/N 18267285N4661AOlson Eric T · Hudson, WIBuilt 1956 · S/N 32258N4661CZiesmer Richard A · University Place, WABuilt 1974 · S/N 18502589N4661MF & W Aviation Co LLC · Wilmington, DEBuilt 1978 · S/N E-1249N4661ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20605998N4662EJgm Aviation LLC · Marion, MTFirst renewal noticeS/N 18268256N4662UMeadow Lakes Aviation · Wasilla, AKBuilt 1964 · S/N 18051362N4663CKnox William D · Denver, COBuilt 1974 · S/N 18502590N4664BSaner Kim K · Soldotna, AKS/N 31562N4665ARegistered aircraftBuilt 1956 · S/N 32262N4665CKrissman Ryan · Gallup, NMBuilt 1977 · S/N U20603841N4666UParadise Adventures LLC · Glenburn, MEBuilt 1964 · S/N 18051366N4667KFletcher Mountain Aviation LLC · Hampden, MEBuilt 1975 · S/N 18263668N46686Skites Ronald W · Salome, AZBuilt 1974 · S/N 18052434N4668MBeechcraft Heritage Museum · Tullahoma, TNBuilt 1978 · S/N E-1252N4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeBuilt 1978 · S/N 414A0061N4669BDunbar Timothy C · Mukwonago, WIBuilt 1955 · S/N 31567N466AMBlue Skies Investments LLC · Eugene, ORBuilt 2005 · S/N 1530N466CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0428N466CDAsa Obion LLC · Union City, TNBuilt 2005 · S/N 1466N466CESilver Fern Aviation Consulting LLC · Port Orange, FLBuilt 2004 · S/N 0999N466GGrabotin Richard C · Dallas, ORS/N D-5776N466KFrancis William R · Provo, UTBuilt 1957 · S/N D-5096N466LSBluefish LLC · Block Island, RIBuilt 1976 · S/N D-9952N466MPMolar Air LLC · Martinez, GABuilt 2004 · S/N 0852N466PJv Aviation LLC · Johnston, RIBuilt 1977 · S/N 310R0988N466QBiziorek Thomas R · Harbor Springs, MIBuilt 1972 · S/N 310Q0534N466RCFlight Specific LLC · Helena, MTBuilt 1974 · S/N TE-995N466TBnab Air LLC · Saint Louis, MOBuilt 2024 · S/N 9846N4670KMaloy Steven · Andrews, NCBuilt 1975 · S/N 18263671N4671BFallin Zachary R · Oracle, AZBuilt 1955 · S/N 31569N4671KNifong Robert B · Jacksonville, FLS/N P21000255N4672ARupert Angus H · Pensacola, FLBuilt 1956 · S/N 32269N4672BHone Christopher J · South Cle Elum, WABuilt 1955 · S/N 31570N4672FWilmeth Roy · Frankston, TXBuilt 1966 · S/N P206-0272N4672KMartin Richard E Trustee · Colorado Springs, COBuilt 1979 · S/N P21000256N4673BRacoon Aviation LLC · San Antonio, TXBuilt 1955 · S/N 31571N4673FCody Richard A · Mclean, VABuilt 1966 · S/N P206-0273
Back to AD 2000-23-21