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.

N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222N4577BHorsley David L · El Paso, TXBuilt 1955 · S/N 31476N4577LLucas John · Norco, CABuilt 1972 · S/N 340-0115N4578NAviation International LLC · El Paso, TXBuilt 1978 · S/N 340A0553N4579FWagner Jan W · Lopez Island, WAS/N 185-1086N4579NSeven Eight Juliet LLC · Edmond, OKBuilt 1978 · S/N 340A0479N457BBRlm Investment Holdings LLC · Wilmington, NCBuilt 1994 · S/N TH-1712N457CBPreferred Aviation Technologies LLC · Mooresville, NCBuilt 2008 · S/N 3058N457DFUsda Forest Service Fepp · Mcclellan, CABuilt 1982 · S/N TH-1354N457DKMiller Gordon J Jr · Monaca, PABuilt 2003 · S/N 29-0313N457DLLeis Donald E · Greenville, OHBuilt 1970 · S/N 18260404N457DMMajor Development LLC · Cedaredge, COBuilt 1978 · S/N 340A0554N457DTMathew Reggie T · Satellite Beach, FLBuilt 1997 · S/N E-3095N457FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10457N457JNToerner Investments · Findlay, OHBuilt 1975 · S/N D-9807N457LMyers Aviation LLC · Mukilteo, WABuilt 1997 · S/N 2352N457MSNesk Aviation LLC · Orlando, FLBuilt 1979 · S/N E-1523N4580EDe Baca Land & Cattle LLC · Jacksboro, TXBuilt 1982 · S/N 18268244N4580JBlakeslee Mark C · Kodiak, AKBuilt 1975 · S/N 180-52509N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223N4581SDaum Jeffrey A · Ocala, FLBuilt 1975 · S/N D-9808N4582ERelis Enterprises LLC · Ravenel, SCBuilt 1982 · S/N 18268245N4583VFoster Mark R · Irvine, CABuilt 1957 · S/N 24729N4584BNadon Peter M · Aztec, NMBuilt 1955 · S/N 31483N4584SAd Astra Aviation LLC · Shawnee, KSBuilt 1975 · S/N E-751N4585BWalchshauser Scott A · Double Oak, TXBuilt 1955 · S/N 31484N4585MCorman Bruce D · Burlington, COBuilt 1978 · S/N E-1239N4585SValiair Limited Company Trustee · Casper, WYBuilt 1975 · S/N E-752N4586BGochenaur Dwight W · York Springs, PABuilt 1955 · S/N 31485N4586SEjh Teton Properties LLC · Petaluma, CABuilt 1975 · S/N D-9809N4587SSims Chad L · Marshall, TXBuilt 1975 · S/N E-753N4588APlane LLC · Shady Shores, TXBuilt 1970 · S/N TE-810N4589NGeneric Implant Solutions LLC · Pratt, KSBuilt 1978 · S/N 340A0556N4589PSecurenet Financial LLC · The Villages, FLBuilt 1961 · S/N D-6798N4589STeebee Aviation LLC · Hixson, TNBuilt 1975 · S/N TC-1902N458BAAlpha Aviation Holding Group LLC · Raleigh, NCBuilt 1975 · S/N TC-1830N458BBLeonard Aviation LLC · Ponte Vedra Beach, FLBuilt 2018 · S/N 4716N458BTBtr Aviation LLC · Somerset, PABuilt 2025 · S/N 11031N458CAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0388N458CPEagle Aviation LLC · Hawarden, IABuilt 2008 · S/N 3255N458CTAratow Michael · Mountain View, CABuilt 2000 · S/N EA-661N458DGIron Street Aviation LLC · North Kansas City, MOBuilt 1973 · S/N TH-296N458DJSurvey America Inc · Rancho Cordova, CABuilt 1980 · S/N U20605833N458EMEchomike Aviation LLC · Las Vegas, NVBuilt 2024 · S/N 9874N458JHVliegtuig Holdings LLC · Kalispell, MTBuilt 1996 · S/N E-3037N458KAugust Aero LLC · Kalispell, MTBuilt 1974 · S/N TH-452N458RHHamil Robert D · Houston, TXBuilt 2005 · S/N 1688N458SKKroenke Seth M · Palmer, AKBuilt 2025 · S/N SS-001N458SRDr2 Aviation LLC · Valdosta, GABuilt 1972 · S/N 18261409N458SSSos Ranch LLC · Humble, TXBuilt 1975 · S/N TH-569
Back to AD 2000-23-21