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.

N203HWConnor Bob L · North Little Rock, ARBuilt 2006 · S/N 72280N203JLJfra LLC · Miami, FLBuilt 1981 · S/N 414A0670N203PLHhj & Rbj Holdings LLC · Prattville, ALBuilt 1976 · S/N D-9898N203RFRapid Flyers LLC · Rapid City, SDBuilt 2003 · S/N 0453N203RTKinzer Richard J · Piney Flats, TNBuilt 1962 · S/N D-6931N203VMyers Daniel Kenneth · Madison, MSBuilt 2007 · S/N 22N2040ASchultz Philip W · Lancaster, CABuilt 1969 · S/N D-9024N2040CWatson Anthony A · Midlothian, TXBuilt 1977 · S/N E-1135N2040GFinal Forge LLC · Blountville, TNBuilt 1978 · S/N E-1380N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183N2040REco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N 18255240N2040UGillim Parvin D · Sheridan, INBuilt 1978 · S/N E-1381N2040XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256140N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181N2041CFly Frannie LLC · Scottsdale, AZBuilt 2023 · S/N 9047N2041GSmith Stacey · Malakoff, TXS/N 51341N2041PManke Brian W · Chesapeake, VABuilt 1978 · S/N CE-821N2041WJimenez John D · San Antonio, TXS/N D-7982N2041ZBlue Mesa LLC · Bend, ORBuilt 1978 · S/N TE-1144N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185N2042ESmith James E Trustee · Kalispell, MTS/N TC-2188N2042RJanssen David W · Ault, COBuilt 1964 · S/N 18255242N2042YPierson Daniel D · Kalispell, MTS/N G-826N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983N2043GBreaking Wind LLC · Alabaster, ALBuilt 1978 · S/N TC-2189N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010N2043XWright Air Service Inc · Fairbanks, AKBuilt 1978 · S/N E-1387N20444Cesafsky Allen A · Bend, ORBuilt 1978 · S/N CE-824N2044GSpear Michael J · Sandpoint, IDBuilt 1958 · S/N 51344N2044KSchutze Curt · Knoxville, TNBuilt 1978 · S/N E-1389N2044PSnoe Gary A · Somerville, TXS/N TC-2178N2044RMiller Steven Chris · Royse City, TXBuilt 1964 · S/N 18255244N2044VPerformance Construction LLC · Paris, TXBuilt 1978 · S/N E-1390N2044WMccraw Richard L Trustee · Hinesburg, VTBuilt 1978 · S/N E-1391N2044XNc Flyers LLC · Raleigh, NCBuilt 1965 · S/N 18256144N2045CBarreto Antonio Trustee · Norco, CABuilt 1978 · S/N E-1392N2045EDouble P Investments LLC · Kerrville, TXBuilt 1978 · S/N E-1393N2045XOsborne David A · Helotes, TXS/N 18256145N20463Merritt Daniel D · Graham, WABuilt 1981 · S/N 18053187N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013N2046WKj Cessna LLC · Waxahachie, TXBuilt 1978 · S/N CE-825N2046YBrainerd William F III · Sapello, NMBuilt 1978 · S/N E-1395N2046ZFreedom Flying Club LLC · Fort Collins, COBuilt 1978 · S/N E-1396N20478V35b Bonanza LLC · Temecula, CAS/N D-10194N2047BField Inspection LLC · Brawley, CABuilt 1978 · S/N E-1394N2047GSatina David J · Norton, OHBuilt 1958 · S/N 51347N2047NAwa Aviation LLC · Sacramento, CABuilt 1978 · S/N E-1400N2047PFromknecht Robert L · Quakertown, PABuilt 1978 · S/N E-1401N2047WKapusta Marian · Clearwater, FLBuilt 1965 · S/N D-7986N2048BCicciari David A · Cincinnati, OHBuilt 1978 · S/N E-1402
Back to AD 2000-23-21