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.

N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263 N231WGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1997 · S/N 25-2003 N231WHJaybird LLC · Goodyear, AZBuilt 1980 · S/N 250370 N231WLObar Daniel C · Middleton, IDBuilt 1979 · S/N 25-0278 N231WMA Davtian M D Medical Services Inc DBA · Glendale, CAS/N 0900 N231WWBaeronautics LLC · Solon, OHBuilt 1979 · S/N 25-0116 N231ZHolland Douglas A · Wichita Falls, TXBuilt 1962 · S/N TC-370 N2320AStructural Integrity Systems LLC · Wichita, KSBuilt 1977 · S/N TC-2113 N2320GStocker Earnest E · Krum, TXBuilt 1959 · S/N 51620 N2320YBauer Steven M · Eliot, MEBuilt 2024 · S/N 10365 N2321FMilson Charles · Sanford, NCBuilt 1964 · S/N 21058521 N2322CTwin Otter Internatinal Ltd · Las Vegas, NVBuilt 1953 · S/N 30622 N2322GBaker Harry K · Phoenix, AZBuilt 1958 · S/N 51622 N2322RSink Lendon V · Lexington, NCBuilt 1964 · S/N 18255422 N2323AOutdoorsmans Dream LLC · Kalispell, MTBuilt 1969 · S/N D-9032 N2323COrvin Sanden Inc · Wyndmere, NDBuilt 1953 · S/N 30623 N2323ECherokee Beech Boys LLC · Kennesaw, GABuilt 1998 · S/N E3187 N2323FMattern Rodney · Napoleon, NDS/N 21058523 N2323GLeone Daniel M · Pueblo, COBuilt 1958 · S/N 51623 N2324AFst Aviation & Logistics LLC · Sheridan, WYBuilt 1997 · S/N E-3124 N2324FLong Rendell L · Woodbridge, VABuilt 1964 · S/N 21058524 N2324RKincheloe Ralph H · Jerome, IDBuilt 1964 · S/N 18255424 N2324XSchutjet Dennis · Clear Lake, IABuilt 1965 · S/N 18256224 N23251Smith Lyndsey P Trustee · Anchorage, AKBuilt 1976 · S/N 18503078 N2325FStephen N Ruark Farm Services Inc · Pantego, NCBuilt 1964 · S/N 21058525 N2325RLucky Catch LLC · Canton, MSS/N 18255425 N2326AValcourt Robert F · Chicopee, MABuilt 1998 · S/N E-3165 N2326BRandigo LLC · Wilmington, DEBuilt 1978 · S/N U20604470 N2326RSinger Don · Oxnard, CABuilt 1964 · S/N 18255426 N2326XFerris Elden L · Vancouver, WABuilt 1965 · S/N 18256226 N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127 N2327FWilliams Stephen Mark · Fort Walton Beach, FLBuilt 1964 · S/N 21058527 N2329GRegistration Pending · Eagle River, AKRegistration pendingBuilt 1959 · S/N 51629 N2329RRivers Andrew · Midland Park, NJS/N 18255429 N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369 N232CDNew Paul · Jackson, TNBuilt 2002 · S/N 0187 N232CGG6 Aviation LLC · Lewisville, TXBuilt 2020 · S/N 2127 N232CHHoover Charles C Jr · Lake Wales, FLBuilt 2006 · S/N 41696 N232DTChancellor Shares LLC · Liberal, KSBuilt 1979 · S/N 414A0232 N232FJConstruct Air LLC · Osage Beach, MOBuilt 2002 · S/N 0338 N232FXAvp II LLC · Winnetka, ILBuilt 1993 · S/N E-2772 N232JBLundell Plastics Corp · Odebolt, IABuilt 1973 · S/N CE-448 N232KASciathain Holdings LLC · Newark, DEBuilt 2021 · S/N 2389 N232MCCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11223 N232MMBuilder Tony Hirst LLC · Kittrell, NCBuilt 2006 · S/N 2302 N232MTAir Force Life Cycle Management Center · Lexington, MABuilt 1981 · S/N U20606200 N232NTorbett Michael G · Lakeway, TXBuilt 1981 · S/N CE971 N232PLDcosta John A · San Jose, CABuilt 2001 · S/N 1159 N232RSWright Aviation LLC · Lawton, OKBuilt 1974 · S/N 310Q1145 N232SRRegistration Pending · Vandalia, OHRegistration pendingBuilt 2006 · S/N 1990

Back to AD 2000-23-21