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.

N1689ZT&R Airplane LLC · Big Lake, AKBuilt 1962 · S/N 1850489N168AERobinson Kevin B · Texarkana, TXBuilt 1963 · S/N 18255158N168AFApogee Flight Inc · Bellingham, WABuilt 1953 · S/N G-299N168AGN168 LLC · Irvine, CABuilt 2024 · S/N 10211N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606N168CDCirrusly LLC · Kalispell, MTBuilt 2000 · S/N 1079N168EDTsg Aviation LLC · Wyandotte, MIBuilt 1975 · S/N 310R0134N168GGWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 414A0304N168JGFlymore LLC · New City, NYBuilt 1999 · S/N E-3253N168LLSteve Jackson Racing LLC · Helena, MTBuilt 2014 · S/N L2K-168N168MNelson Lars C · Anchorage, AKBuilt 1968 · S/N D-8762N168MPValiair Ltd Co Trustee · Casper, WYBuilt 2007 · S/N 2692N168NLLakeside Views LLC · La Crescenta, CABuilt 1966 · S/N CE-45N168PSBkt LLC · Leawood, KSBuilt 2023 · S/N 9173N168SABruchid Snodgrass LLC · Reno, NVBuilt 1981 · S/N U20606073N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460N168SRWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 2006 · S/N 1747N168ULeading Edge LLC · Scottsdale, AZBuilt 1969 · S/N D-8986N168WACharles Michel · St Thomas, VIBuilt 1984 · S/N 402C0808N1690RFederal Aerial Applicators LLC · Wilmington, DEBuilt 1974 · S/N 18502413N1690WHarran Patrick · Santa Monica, CABuilt 1972 · S/N D-9391N1691CSchrom Edward C · Manchester, PABuilt 1952 · S/N 30391N1692CVandevoorde Gary A · Davenport, IABuilt 1953 · S/N 30392N1692MClark Shawn W · Anchorage, AKBuilt 1971 · S/N 18501877N1693CDeardorff Dallas · Plains, MTS/N 30393N1693WAntique Endeavors LLC · Missoula, MTBuilt 1972 · S/N D-9389N1694MWraith Lane T · Wasilla, AKS/N 18501879N1694RCrow Rock LLC · Stillwater, MNBuilt 1974 · S/N 18502417N1694WKlauber James S Sr · Boonsboro, MDBuilt 1972 · S/N E-363N1695CSpeed Richard · Boise, IDBuilt 1953 · S/N 30395N1695MGc Profits Inc · Reedley, CABuilt 1975 · S/N 18264415N1695WVon Seggern Robert J · Chesterfield, MOBuilt 1972 · S/N D-9393N1696CCarraher Mark T · Spalding, NEBuilt 1953 · S/N 30396N1696WLove Richard F · Lakeland, MNBuilt 1972 · S/N CD-1300N1696XCenturion LLC · New Bern, NCBuilt 1975 · S/N 21060731N1697WMountcastle Creek LLC · Pratt, KSBuilt 1972 · S/N E-365N1698VStem Aviation Academy · Carlsbad, CABuilt 1976 · S/N R1722209N1698WLawrence John · Dayton, NVBuilt 1972 · S/N D-9392N1698XCmo Blue Sky LLC · Tomball, TXS/N 21060733N1699CGrismer Jeff Trustee · Hemet, CABuilt 1953 · S/N 30399N1699MCodner Nicholas Jr · Londonderry, NHBuilt 1975 · S/N 18264416N1699WDkp Holdings LLC · Melbourne Beach, FLBuilt 1973 · S/N E-399N1699ZSkopec David P · Bend, ORS/N 1850499N169BZTailhook Industries LLC · Chandler, AZBuilt 2006 · S/N L2K-241N169CDGroseth Cyler D Sr · Surprise, AZFirst renewal noticeS/N 1077N169DKStanton James · North Barrington, ILBuilt 1978 · S/N 310R1412N169DPAdrenaline Inc · Chambersburg, PAS/N 34979N169DWA&P Properties LLC · Manns Choice, PABuilt 2005 · S/N 1523N169EBMutyala Susheel V · Bellevue, WABuilt 2001 · S/N 3449230N169FTHolmstrom Darrell D Trustee · Anchorage, AKBuilt 1956 · S/N 32389
Back to AD 2000-23-21