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.

N234ATr Aero LLC · Poway, CABuilt 1972 · S/N TC-1437 N234ABBachteal Paul Shear · Sebastopol, CABuilt 1991 · S/N CE-1562 N234ADRadar Ventures LLC · Truckee, CABuilt 2015 · S/N T24002073 N234AFFanswoop LLC · Cincinnati, OHBuilt 2016 · S/N 1321 N234AKKihneman David J · Spring, TXBuilt 2007 · S/N 2878 N234APOrr Lynn E · Fredericksburg, OHBuilt 1988 · S/N CE-1232 N234BJJmc Commercial Contractors LLC · Porter, TXBuilt 2007 · S/N 2541 N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290 N234CL40 Richmond LLC · Pittsfield, MABuilt 2010 · S/N 0050 N234CMTallman Donald Depaul · Venice, FLBuilt 1966 · S/N 18257696 N234CROcf Air LLC · Phoenix, AZBuilt 2010 · S/N 0016 N234CSCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11639 N234CWWright Caleb · Douglas, GABuilt 2015 · S/N 4261 N234CZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 2548 N234DDNunez Christian · Grand Prairie, TXBuilt 1973 · S/N 73-30528 N234DHCarrell Evan Paul · Queen City, TXBuilt 1969 · S/N D-8966 N234DPConnect 4 Ventures LLC · Woodberry Forest, VABuilt 2024 · S/N 10214 N234DWN234dw Aviation Inc · Okemos, MIBuilt 1974 · S/N 310R0008 N234E234 E Aviation LLC · Branford, CTBuilt 2023 · S/N 9074 N234EBArbuckle James H · Bellevue, NEBuilt 1966 · S/N D-8157 N234ETAir Fergie LLC · Camden, DEBuilt 2026 · S/N 11257 N234FNelson Graig M · Eastsound, WABuilt 1955 · S/N 32142 N234FS234fs LLC · Ponte Vedra Beach, FLBuilt 1955 · S/N 53-4132 N234FYVee Two Inc · Merritt Island, FLBuilt 1978 · S/N 347870428 N234GLL J Aircraft LLC · Cedar City, UTBuilt 1966 · S/N CE-112 N234GTAny Border LLC · Yankton, SDBuilt 1977 · S/N 21062155 N234HKExplore Aviation LLC · Santa Barbara, CABuilt 2006 · S/N 1746 N234JFaliero Bryan K · Greenville, SCBuilt 2025 · S/N 10754 N234JEAimrich Enterprises · Wilmington, DEBuilt 1987 · S/N CE-1193 N234JPBistline Worth · New Harmony, UTS/N 25-0277 N234JSOcean Blue Aviation LLC · Farmingdale, NYBuilt 1976 · S/N 18502956 N234KBRegistration Pending · Wenatchee, WARegistration pendingBuilt 2026 · S/N 11440 N234KRRhume LLC · Carson, CABuilt 2023 · S/N 9460 N234KTCessna 182 LLC · Kitty Hawk, NCBuilt 2004 · S/N 41023 N234MBSonday Terrance P · Red Lodge, MTBuilt 1956 · S/N BG-199 N234MCStauffer Charles I · Battle Creek, MIS/N BG-411 N234MGDubin Wayne M Trustee · Fort Myers, FLBuilt 1977 · S/N TE-1104 N234MJMj Aviation LLC · Mooresville, NCBuilt 2018 · S/N 1673 N234MSVertical Horizon Aviation LLC · Sandown, NHBuilt 1975 · S/N 3400351 N234MWKuehn Kevin C · De Pere, WIBuilt 1964 · S/N 310I0034 N234PDAccurite Machine & Manufacturing Inc · Louisville, KYBuilt 2004 · S/N 1167 N234PGSpeer Aircraft LLC · Evansville, INBuilt 2004 · S/N 0935 N234PKHintz Courtney N · San Antonio, TXBuilt 1963 · S/N 18254645 N234PSTkn Holdings LLC · Pima, AZBuilt 1977 · S/N 340A0368 N234PTJaguar Management Group LLC · Wilmington, DEBuilt 2000 · S/N EA-662 N234PWRight Rudder LLC · Sapulpa, OKBuilt 1978 · S/N 18266103 N234PYAqua Aviation LLC · Winnetka, ILBuilt 2019 · S/N 1908 N234QASteinke Mark · Camas, WABuilt 1959 · S/N 52409 N234RBMoyer Thomas L · Fayetteville, GABuilt 1976 · S/N TC-1950 N234SASun Valley Energy Investments LLC · Gainesville, GABuilt 2024 · S/N 10372

Back to AD 2000-23-21