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.

N3096QMorgan County Aviators LLC · Fort Morgan, COBuilt 1967 · S/N 18258096N3096TBakamis Joel Alexander · South Lake Tahoe, CABuilt 1988 · S/N CE-1208N3096WPickering Paul S · Granbury, TXBuilt 1994 · S/N CE-1786N3096YHerrman Robin A · Connell, WABuilt 1962 · S/N 18254096N3097CAviation Hangar LLC · Wentzville, MOBuilt 1958 · S/N D-5787N3097WYarbrough G Mark · Sandia Park, NMBuilt 1973 · S/N CE-473N3097YKlenke Nathan D · Seward, NEBuilt 1962 · S/N 18254097N3099CTurpin Terry S · Foster City, CABuilt 1958 · S/N D-5782N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561N3099YPerkins Scott B · Thomas, OKFirst renewal noticeBuilt 1962 · S/N 18254099N309CACloud Niner LLC · Levittown, NYBuilt 2026 · S/N 11198N309CDTriangle Aviation LLC · Cary, NCBuilt 2004 · S/N 1104N309CPCirrus 497pg LLC · Scottsdale, AZBuilt 2008 · S/N 3232N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309N309JFRozo Matthew · Chatsworth, CABuilt 2002 · S/N 0266N309JLHangar 15 LLC · Saint Martinville, LABuilt 2008 · S/N 411010N309LSPure Pursuit LLC · Arnold, MDBuilt 2022 · S/N 8659N309PTNelems Manufacturing LLC · Beaufort, SCBuilt 2007 · S/N 2434N309SCCalcote Derrick · Arlington, TNBuilt 2006 · S/N 2207N309SRWise Aviation LLC · Atlanta, GABuilt 2007 · S/N 2309N309XBernacki David A · Clyo, GABuilt 1975 · S/N 6125CN30AAOcean Lighthouse LLC · Central, SCBuilt 1991 · S/N 003N30AWKnox Tommy J · Lampasas, TXBuilt 1974 · S/N 18502369N30CAState Of California Department Of Transportation · Sacramento, CABuilt 1974 · S/N CE-508N30CMBoardman Air Service LLC · Henderson, NEBuilt 1974 · S/N 18502443N30CTLaidley Robert F · Erie, COBuilt 1978 · S/N 182-66446N30CWBrownd Gregory H · Shallowater, TXBuilt 1958 · S/N D-5636N30DMNagle Derek · Ada, MIBuilt 1979 · S/N E-1536N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N30EWThree Zero Echo Whisky Inc · Wilmington, DEBuilt 1976 · S/N 21061412N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067N30GHAvientur LLC · Chesterfield, MOBuilt 2007 · S/N E-3761N30GPCedar Mountain Respiratory Inc · Athol, IDBuilt 1975 · S/N P3370212N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079N30KJCrist Carry R · Crete, NEBuilt 1957 · S/N D-5181N30LFSignalwave LLC · Doral, FLBuilt 1980 · S/N EA-122N30LGHusky Two Associates LLC · Brookline, MABuilt 2020 · S/N E-4145N30LNRaymon Rodherick L · Enterprise, ALBuilt 2002 · S/N 40046N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995N30MKKelly Michael E · Cumberland, RIBuilt 1981 · S/N CE-989N30MSFlying Medical Service · Grosse Pointe, MIBuilt 1974 · S/N U20602620N30MTMcnamara J Kevin · Cascade, IDBuilt 1977 · S/N U20604086N30NDPak Aviation LLC · Birmingham, ALBuilt 2001 · S/N 3449233N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N30RECalifornia Aviation LLC · Fresno, CABuilt 1979 · S/N 79-30935N30RFBonsal John R · Flower Mound, TXBuilt 1978 · S/N CJ-142N30RMDaniel Warren · Naples, FLBuilt 1971 · S/N TE-828N30RPCommunications Laboratories Inc · Melbourne, FLBuilt 1982 · S/N E-2050
Back to AD 2000-23-21