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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N35MDGarbalosa Ryan · Myrtle Beach, SCBuilt 1995 · S/N 29-0047 N35MQFly Planet LLC · Kalispell, MTBuilt 1973 · S/N 18262505 N35MTToft Michael O · Brock, TXBuilt 1966 · S/N D-8338 N35MVWeaver Kibwe · Kalamazoo, MIBuilt 1967 · S/N D-8617 N35MXMontanez George O · Mesa, AZBuilt 1960 · S/N D-6411 N35NBBert John Boyd III · Vero Beach, FLBuilt 1975 · S/N D-9802 N35NYPerry Charles E · Aldie, VABuilt 1970 · S/N D-9193 N35QTReady Aim Flyer LLC · New Castle, DES/N D-8839 N35RBBarnes Roger A · Cheyenne, WYBuilt 1963 · S/N D-7219 N35RCG5 Aviation Inc · Englewood, COBuilt 1964 · S/N D-7393 N35REDakota Aero Inc · Steamboat Springs, COS/N D-8930 N35RMSuell Tommy R · North Las Vegas, NVBuilt 1983 · S/N 06 N35SHulteen Grant S · Tumwater, WABuilt 1964 · S/N D-7481 N35SCCramp Steven J · Cleveland, TXBuilt 1973 · S/N D-9442 N35SNPlane Fun Inc Tr Trustee · Snellville, GABuilt 1960 · S/N CD-207 N35TBCencalcom Inc · Santa Barbara, CABuilt 1977 · S/N D-9985 N35TCLynn David R · Mobile, ALBuilt 1964 · S/N CD-776 N35TDShelton Aviation LLC · Salem, ORBuilt 1993 · S/N EA-555 N35TEOusley James Dean Jr · Granbury, TXBuilt 1979 · S/N E-1550 N35TJBeech D9462 LLC · Perry, OHBuilt 1973 · S/N D9462 N35TPMccallister Mark A · Qulin, MOBuilt 1977 · S/N D-10018 N35TTJ B & B LLC · Midwest City, OKBuilt 1965 · S/N D-7812 N35UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N D-6795 N35VBEquipment Lessors Inc · Lake Hawatha, NJBuilt 1977 · S/N D-10000 N35VEMckibben Howard Stephens · Elk Grove, CABuilt 1961 · S/N D-6694 N35VHBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 18268129 N35VSRcp3 Enterprises LLC · Chesterfield, MOBuilt 1966 · S/N D-8247 N35WD4lo Air & Land LLC · Damascus, ORS/N 2050234 N35WPWhite Pine Aviation LLC · Park City, UTBuilt 2025 · S/N 10990 N35XFCaudle David William · Arlington, TXBuilt 1958 · S/N D-5674 N35XLWilliams James R · Scotts Valley, CABuilt 1964 · S/N D-7321 N35XPFletcher Lance · Germantown, OHBuilt 2011 · S/N 3716 N35XTWrench John D · Los Olivos, CABuilt 1978 · S/N 18266390 N35YRTonini Farm And Cattle Co · San Luis Obispo, CABuilt 1982 · S/N D-10397 N35YTArmstrong Samuel V · Lovelock, NVBuilt 1955 · S/N D4058 N3600URiera Jose Gregorio · Saint Augustine, FLBuilt 1963 · S/N 18255000 N3600XInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 0491 N3601CLloyd Land Plane IV LLC · Brighton, COBuilt 1954 · S/N 31099 N3601YFirst Cut Excavation LLC · Hamilton, MTBuilt 1962 · S/N 21058101 N3602UBritsch Michael J · Anchorage, AKS/N 18255002 N3602YMissionary Aviation Repair Center · Soldotna, AKBuilt 1962 · S/N 21058102 N3603YCarter Duane Lee · Madison, GABuilt 1962 · S/N 21058103 N36049Koppenhaver Seth Tyson · Oro Valley, AZBuilt 1978 · S/N 34-7870287 N3604CCosby Asa L · Weldon, CABuilt 1954 · S/N 31102 N3605CChambers Joseph B · Oswego, NYBuilt 1954 · S/N 31103 N3605MIsland Bound LLC · Dunedin, FLBuilt 1978 · S/N 34-7870118 N3605PSmith Bryan · Wenatchee, WABuilt 1978 · S/N P21000040 N3605YVita Clean Services · Wenatchee, WABuilt 1962 · S/N 21058105 N36067Armor Corps Inc · Spring Hill, TNBuilt 1978 · S/N 28R-7803309 N3606CHendrix Grant Mcmahill · University Place, WABuilt 1954 · S/N 31104

Back to AD 2000-23-21