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.

N3708KWard Ron · Oklahoma City, OKBuilt 1980 · S/N EA-153N3708UCollins George H · Murfreesboro, TNBuilt 1963 · S/N 18255108N37091Lee James P · Madisonville, TNBuilt 1980 · S/N E-1761N3709DAbidance Inc · Winthrop, WABuilt 1957 · S/N 34409N3709UMoser Scott M · Pisgah Forest, NCS/N 18255109N370BMChad Davison Insurance Agency Inc · Bend, ORBuilt 2015 · S/N 1020N370GAir Land Ventures LLC · Highland Park, ILBuilt 2003 · S/N 0783N370JCSouth Oaks Inc · Hollywood, FLBuilt 1977 · S/N U206-04024N370JGGuideair LLC · Eden Prairie, MNBuilt 2004 · S/N 1123N370JR110 Aviation LLC · West Des Moines, IABuilt 2024 · S/N 9849N370RAmerican Aircraft Management LLC · Irving, TXBuilt 1980 · S/N U20605501N370SDGreat Cloud Design Inc · Dunedin, FLNon-citizen corporation, flight hours not reportedBuilt 1969 · S/N 69-7659N3710DHiller Paul D · Grafton, OHBuilt 1957 · S/N 34410N3710UFollette Aviation LLC · Scottsdale, AZBuilt 1963 · S/N 18255110N3711WMccaul Benjamin · San Luis Obispo, CABuilt 1980 · S/N E-1762N3711YAero Venture Lc · Shreveport, LABuilt 1977 · S/N TH-828N37126Robison Charles T · Pierre, SDBuilt 1980 · S/N EA-156N3712QThomas Gregory O Trustee · Derby, KSBuilt 1966 · S/N CE-133N3712UVarian Dennis D · West Lafayette, OHBuilt 1963 · S/N 18255112N3712VImperium Solutions LLC · Cheyenne, WYBuilt 1977 · S/N R1722261N3712YRpx Technologies Inc · Stillwater, OKBuilt 1963 · S/N 21058212N3713DHedgecock David H · Elkhorn, WIFirst renewal noticeBuilt 1957 · S/N 34413N3713QAirborne Adventures LLC · Clive, IABuilt 1966 · S/N D-8370N3713UDaggy Curt L III · Red Bluff, CABuilt 1963 · S/N 18255113N3714DZombo Brian T · Youngsville, NYBuilt 1957 · S/N 34414N3714USchaffer John Paul · Prior Lake, MNBuilt 1963 · S/N 18255114N3714YReichelt Mark C · Big Sandy, MTBuilt 1963 · S/N 21058214N3714ZQuick Foam Insulation LLC · Lubbock, TXBuilt 1980 · S/N EA-160N3715BNova Jets USA Corp · Orlando, FLBuilt 1980 · S/N TH-1200N3715CHangar Ten LLC · Westfield Center, OHS/N TC-2391N3715JSmoot Nathan · Fairbanks, AKS/N 18255115N3715QShellington Justin R · Columbus, NJBuilt 1966 · S/N D-8375N3716QHoward Michael I · Shelley, IDBuilt 1967 · S/N TE-297N3716UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1963 · S/N 18255116N3717YOwosso Navigators Club LLC · Owosso, MIBuilt 1963 · S/N 21058217N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511N3719DVector Stunts Inc · Bend, ORBuilt 1957 · S/N 34419N3719UOlsen Marvin J · Kent, WABuilt 1963 · S/N 18255119N3719YG & G Famrs Of Gilbert Inc · Gilbert, LAS/N 21058219N371BBtf Ventures LLC · Kalispell, MTBuilt 1957 · S/N D-5069N371BBLake Peipsi LLC · Williamstown, WVBuilt 2000 · S/N E-3355N371BGCzok Justin · Park Ridge, ILBuilt 2005 · S/N 41104N371CDEicholz Robert Trustee · Palm Springs, CABuilt 2005 · S/N 1434N371CKFish Sandwich LLC · Orlando, FLBuilt 2003 · S/N 1307N371ECNext1sr LLC · Dayton, OHBuilt 2025 · S/N 10487N371JMYates Industries LLC · Artesia, NMBuilt 2008 · S/N E-3843N371PMElias Miguel A · Kenner, LAS/N 4371N371SLOrnelas Sergio L · Santa Teresa, NMBuilt 2017 · S/N 1652N371STSierra Aviation LLC · Fort Lauderdale, FLBuilt 2026 · S/N 11145N371XWalker George R · Mableton, GABuilt 1976 · S/N 6167C
Back to AD 2000-23-21