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.

N29DAJones David W · Carlisle, PABuilt 1975 · S/N TH-645N29DCDwlg Aviation LLC · Rogers, ARBuilt 1965 · S/N D-7943N29DLCrouch David T · Asheville, NCBuilt 1976 · S/N E-913N29DXLima Mike LLC · Springdale, ARBuilt 2020 · S/N 2158N29EALorimor Thomas T · Sidney, IABuilt 1976 · S/N CE622N29EMIngram Earl · San Marcos, TXBuilt 2007 · S/N 29-0494N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813N29FZTrn Aviation LLC · Mcallen, TXBuilt 1977 · S/N 28R7703052N29HCInternational Air Services Inc Trustee · Carson City, NVS/N 3449073N29HHPalmetto Aviation LLC · Annapolis, MDBuilt 2006 · S/N 41580N29HPRusso Kevin J · North Branch, NJBuilt 1976 · S/N E-831N29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450N29KGCalvin M Holdings LLC · Dania, FLBuilt 2014 · S/N 4148N29KK29kk LLC · Manchester, MIBuilt 2003 · S/N 40071N29KLN13kl LLC · Lewes, DEBuilt 2003 · S/N 3302N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579N29MALongbow Aviation Ventures Ltd · Las Vegas, NVBuilt 2020 · S/N 2057N29MFChas N Clark Associates Ltd · Laurel, MSBuilt 2000 · S/N TH-1966N29PCFisher Douglas C · Mountain View, CABuilt 1979 · S/N 18266929N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N29PPBevis Thomas L · Sebring, FLBuilt 1971 · S/N 2061CN29RFCaldwell Rob · Danville, KYBuilt 1979 · S/N E-1445N29RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1982 · S/N TC-2451N29RRKhg Aviation Holdings LLC · Columbus, OHBuilt 1982 · S/N TJ-414N29SFDillon Jade E · Thornton, COBuilt 1976 · S/N TC-1952N29SLJ1 Mobility LLC · Charleston, SCBuilt 2022 · S/N 8780N29SRAviation USA LLC · Anchorage, AKBuilt 1978 · S/N 18503582N29TCBeach Bonanza LLC · Shreveport, LABuilt 1991 · S/N E-2644N29UN29ny LLC · Eatontown, NJBuilt 2021 · S/N 2418N29UAN29ny LLC · Eatontown, NJBuilt 2005 · S/N 1282N29VRegistered aircraftBuilt 1972 · S/N D-9340N29WC29wc Inc · Malta, NYS/N E-1642N29WHSr-22 Partners LLC · Danville, CABuilt 2004 · S/N 0974N29XXMustang Aeronautics LLC · Chandler, AZBuilt 1975 · S/N 421C0035N2AASapphire Skies LLC · Kalamazoo, MIBuilt 2009 · S/N L2K-251N2BG2fly LLC · Seattle, WABuilt 2009 · S/N 3458N2BBLowry Air LLC · Tahlequah, OKBuilt 1972 · S/N TC-1447N2BHNethery Cattle Company LLC · Fort Worth, TXBuilt 2018 · S/N E-4117N2BKPrevost Christopher D · Sonoma, CABuilt 1951 · S/N 21648N2BLInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 25-0104N2CBBoxman LLC · Wilmington, DEBuilt 1977 · S/N D-10090N2CKPegasus Aviation Services LLC · Jupiter, FLBuilt 2024 · S/N 10355N2CLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R-8131054N2CSBolton Geoffrey M · Groveland, CABuilt 1973 · S/N D-9463N2CWMiller Steven D · Mccall, IDS/N 18502486N2DCGottsleben John J · Tucson, AZBuilt 1964 · S/N D-7318N2DMWiley Post LLC · Lewes, DEBuilt 1970 · S/N 21059305N2DNHaines Matthew E · Lake Dallas, TXBuilt 1973 · S/N D-9426N2DRGustafson Dale H · Kingwood, TXBuilt 1962 · S/N D-6924
Back to AD 2000-23-21