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.

N337RSDinwiddie Michael R · Sunbury, OHS/N P3370074N337RTTorres Ramon A · Mulberry, FLBuilt 1965 · S/N 337-0089N337RWRamey Chris M · Simpsonville, KYBuilt 1977 · S/N P3370295N337SSState Of Wisconsin/Doa · Madison, WIBuilt 1976 · S/N 33701716N337SVLillie Ronald G · Salt Lake City, UTS/N 337-0628N337TGSafe & Sound LLC · Kalispell, MTBuilt 1979 · S/N P3370281N337TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 33701462N337TLInternational Air Services Inc Trustee · Carson City, NVS/N 33701418N337TMFowler James Md · Mcallen, TXBuilt 2011 · S/N 0160N337TRDel Rio Aviation Inc · Paso Robles, CABuilt 1967 · S/N 337-0648N337TSWalz Steve · Kiowa, KSBuilt 1966 · S/N 337-0300N337TWRtw Aviation LLC · Tulsa, OKBuilt 1977 · S/N P3370299N337TXBlue Skies Aviation Services LLC · Bynum, TXBuilt 1968 · S/N 337-0801N337USkymaster Mods & Parts LLC · Castalian Springs, TNS/N P3370346N337VRed Devil Skymasters LLC · Helena, MTBuilt 1971 · S/N 33701369N337VGBvj Skymaster Inc · Appleton, MNS/N 337-0435N337WAGyron Eagle Ltd · Pasadena, CABuilt 1975 · S/N 33701651N337WGGrady Charles Martin · La Verne, CABuilt 1965 · S/N 337-0091N337WTSunset Aviation LLC · Wilmington, DEBuilt 1967 · S/N 337-0661N337WWTobias John M · Sedona, AZBuilt 1973 · S/N P3370106N337WZAir Data Solutions LLC · Natchitoches, LABuilt 1971 · S/N 33701397N337XXPfister David E · Harlan, INS/N 337-0726N337YBrokaw Burton · Tucson, AZBuilt 1966 · S/N 337-0449N33809Iaba LLC · Norfolk, VABuilt 1975 · S/N 34-7570165N3380DRussell Robert J · Wasilla, AKBuilt 1956 · S/N 32178N3380RHunter Robert R · Springville, PABuilt 1967 · S/N 18258680N3380YLaramie Flying Club Inc · Laramie, WYBuilt 1962 · S/N 18254380N3381FAttema Symon Nmi · Norco, CABuilt 1966 · S/N 18257381N3381UCenter Of Excellence Corp · Cheyenne, WYBuilt 1963 · S/N 18254781N3382DBond Jeffrey A · Las Cruces, NMBuilt 1955 · S/N 32180N3382RWatch Out LLC · Scottsdale, AZBuilt 1967 · S/N 18258682N3382SNorthern Sonic Alaska Inc · Fairbanks, AKBuilt 1973 · S/N 18502288N3382YJenkinson John III · Lakin, KSBuilt 1962 · S/N 18254382N33832Shafer James H · Port Orchard, WABuilt 1975 · S/N 34-7570168N33833Buchholz David M · Scottsdale, AZBuilt 1975 · S/N 34-7570169N3383DStyer Michael J · Amarillo, TXBuilt 1955 · S/N 32181N3383RDeatley Derek · Mohave Valley, AZBuilt 1967 · S/N 18258683N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183N3383YJohnson Brian B · Monroe, LABuilt 1962 · S/N 18254383N3384R3384 Romeo LLC · Jackson, MOBuilt 1967 · S/N 18258684N3384YOliveira John S · Plant City, FLBuilt 1962 · S/N 18254384N3385LTonka Seaplanes LLC · Minnetonka, MNS/N 185-1337N3385RHill David A Jr · Needham, MABuilt 1967 · S/N 18258685N3385YNoah Aviation LLC · Ellabelle, GABuilt 1962 · S/N 18254385N3386FN3386f Flying Club Inc · Pickerington, OHBuilt 1966 · S/N 18257386N3387FChristensen Robert F · Gillette, WYBuilt 1966 · S/N 18257387N3387RSkypartners LLC · Buhler, KSBuilt 1967 · S/N 18258687N3387USkynick Enterprises Inc · Tarzana, CAS/N 18254787N3387YBhogal Balvinder S · Biloxi, MSBuilt 1962 · S/N 18254387N3388RFamily Air Fares LLC · Wilmington, DEBuilt 1967 · S/N 18258688
Back to AD 2000-23-21