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.

N4811DAbidance Inc · Winthrop, WABuilt 1958 · S/N 34911N4811NMiller Edwin C · Proctor, WVS/N 18267385N4811USwartz Ryan W · Pierre, SDBuilt 1963 · S/N 205-0511N4812CRennekamp Eric J · Andersonville, TNBuilt 1981 · S/N 18268132N4812FNorth American Aerial Surveys LLC · Tucson, AZBuilt 1966 · S/N U206-0512N4812UFoster Frank Brian · Goldsboro, NCS/N 205-0512N4813MCouch Walter J · Patterson, LABuilt 1978 · S/N E-1265N4813P4813p LLC · Newport, MEBuilt 1978 · S/N P21000115N4814Crawford Benjamin D · Anchorage, AKBuilt 1957 · S/N 32847N4814UHash Marshall T · Inglis, FLBuilt 1963 · S/N 2050514N4815Ober John A · Candor, NYS/N 18053056N4815BCochise Community College · Douglas, AZBuilt 1955 · S/N 35115N4815DBodeen Lance A · Eagle River, AKBuilt 1958 · S/N 34915N4815JRise Ronald B Jr · Purcellville, VABuilt 1966 · S/N CE-114N4816JMorten Derek J · Northwood, NDBuilt 1981 · S/N T18803768TN4816RA&C Ag Aviation Inc · Unadilla, GABuilt 1975 · S/N 18802336TN4817DWirt James · Goldsby, OKBuilt 1958 · S/N 34917N4819JDoran Jeffrey T · Westerville, OHS/N CD-1060N4819NSilva Robert · Davis, CABuilt 1979 · S/N 18267391N4819QPuryear Rodney K · Pampa, TXBuilt 1976 · S/N 18802556TN481CDMeyer Eric · Fort Lauderdale, FLBuilt 2005 · S/N 1488N481DGrey Goose LLC · Wasilla, AKBuilt 1957 · S/N 50255N481DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1823N481FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10481N481GJGdjones Aviation LLC · Blue Mounds, WIBuilt 2024 · S/N 10302N481HWilliams Stephen C · Georgetown, MEBuilt 1961 · S/N 185-0116N481JCollins Jason · Mansfield, OHBuilt 1977 · S/N 21061580N481MWN481mw LLC · Reno, NVBuilt 2025 · S/N 10675N481PMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1977 · S/N U20603684N481RABoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1643N481SAerogracia LLC · Heritage Ranch, CABuilt 1970 · S/N D-9094N481TN481t LLC · Pensacola, FLBuilt 1961 · S/N CD-310N481TRBowen Tim S · Robstown, TXBuilt 1978 · S/N U20604383N4820EHogan Mark C · Sisters, ORBuilt 1979 · S/N 18503880N4821USouth Side Corp · Loomis, NEBuilt 1963 · S/N 205-0521N4822DRegistered aircraftBuilt 1958 · S/N 34922N4822NBalinski Stephen W · Lusby, MDBuilt 1979 · S/N 18267394N4822VCantrell David R · Albany, GABuilt 1968 · S/N 30092N48233Miller Robert S · Mesa, AZBuilt 1968 · S/N 337M0294N48237Yoder Airways LLC · Fayetteville, GABuilt 1967 · S/N R172-0171N4823JHaunstein Manfred · Weirsdale, FLBuilt 1966 · S/N D-8337N4824FWheeler Michael P · Declo, IDBuilt 1966 · S/N U206-0524N4825DHitec Construction Services Inc · Lincoln, CABuilt 1958 · S/N 34925N4825EParis Enterprises LLC · Atlanta, GABuilt 1979 · S/N 18503883N4825NBlue 79 LLC · Loogootee, INBuilt 1979 · S/N 18267397N4826DTurbine Training Center Inc · Manhattan, KSBuilt 1958 · S/N 34926N4827DWebber David A · Delta Junction, AKBuilt 1958 · S/N 34927N4827PCarlson Chris · Redwood City, CABuilt 1978 · S/N P21000119N4827UHagen Rainer · Irving, TXBuilt 1979 · S/N U20605119N4828DNisbet William T · Driggs, IDBuilt 1958 · S/N 34928
Back to AD 2000-23-21