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

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.

N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045 N190CDMontague Paul N III · Vancouver, WABuilt 2000 · S/N 1099 N190DMMcintyre Donald F · Fort Gratiot, MIBuilt 1978 · S/N 18266049 N190DRLehrke Thomas Alan · Bloomington, MNBuilt 2001 · S/N 29-0279 N190DWSouthern Sky Ventures LLC · Lewes, DEBuilt 2003 · S/N 42002 N190FTWestchester Flying Club Inc · Purchase, NYBuilt 1978 · S/N 28R-7837245 N190JHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3660 N190P98 Mike LLC · Hayden, IDBuilt 1964 · S/N P206-0012 N190QMcgilvray Saxon · Helena, MTBuilt 1964 · S/N D-7551 N190SRFlyby Air LLC · New Orleans, LABuilt 2007 · S/N 2641 N190TNMi-6 LLC · Helena, MTBuilt 2008 · S/N 31-0090 N1910MMob Aviation USA LLC · Auburndale, FLBuilt 1975 · S/N 18264475 N1911JD M C Aviation LLC · Jennings, LABuilt 1971 · S/N E-298 N1911XSs Aviation LLC · Preston, IDBuilt 1965 · S/N 18256011 N1912LRegistered aircraftBuilt 1976 · S/N E-866 N1912XWhite Charles S · Anacortes, WABuilt 1965 · S/N 18256012 N1913LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N CE-656 N1913XYates Craig J · Indialantic, FLBuilt 1965 · S/N 18256013 N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429 N1916Rauser Richard A Trustee · Cottonwood, CABuilt 1974 · S/N 18263299 N1916XCannon Aviation LLC · Morgan, UTBuilt 1965 · S/N 18256016 N1917UPinewood Homes LLC · Hayward, WIBuilt 1969 · S/N 185-1588 N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668 N1918MWalker Stephen L Trustee · Andover, KSBuilt 1975 · S/N 18264481 N1918XCarlson Brent A · Shelley, IDBuilt 1965 · S/N 18256018 N1919JValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 310R1554 N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271 N191AAPelz Thomas G · Boscobel, WIBuilt 1959 · S/N D-5914 N191AHCirrus Sr22t Athens Blue Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2354 N191BFKoziura Sebastian · Evanston, ILBuilt 1991 · S/N CE-1577 N191BSChambers Jason Daniel · Marion, MTBuilt 2007 · S/N 2733 N191BWSung Properties LLC · Visalia, CABuilt 2005 · S/N 1577 N191CCCarter Cleveland M · Willacoochee, GABuilt 1972 · S/N CE-399 N191CDInzerillo Richard C · West Coxsackie, NYBuilt 2000 · S/N 1100 N191CTBessemer Plywood Corp · Bessemer, MIBuilt 1974 · S/N 310R0057 N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022 N191FPravin Aturalita · Duluth, MNBuilt 1964 · S/N TC-716 N191FRPlane Sol LLC · San Antonio, TXBuilt 2015 · S/N T24002083 N191GA5056 Bonanza LLC · Tulsa, OKBuilt 1957 · S/N D-5056 N191JBGraeves Auto & Appliance Inc · Olney, MDBuilt 2016 · S/N 1396 N191JGBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1699 N191JHJack Henry And Associates Inc · Monett, MOBuilt 1982 · S/N E-2042 N191KMDodson International Parts Inc · Rantoul, KSS/N 0017 N191LNSrr LLC · Central Lake, MIBuilt 2005 · S/N 1548 N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720 N191WFletcher Flying Service 419 LLC · Labelle, FLBuilt 1964 · S/N TC-577 N191WEFs Mickey LLC · East Lansing, MIBuilt 1975 · S/N TE-1059 N191WLHatchery Investments LLC · Truckee, CABuilt 2015 · S/N 1098 N191WTBrightpipe Air LLC · Mableton, GABuilt 2025 · S/N 11057 N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172

Back to AD 2000-23-21