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.

N42ACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11618 N42AAN42aa LLC · Nantucket, MABuilt 1979 · S/N 402C0238 N42AMGruhlkey William H · Wildorado, TXBuilt 1979 · S/N EA-29 N42AUBite Wing Aviation LLC · Wichita, KSBuilt 1982 · S/N CE-1010 N42AVIsland Aero LLC · East Northport, NYBuilt 1982 · S/N 18268267 N42BDKristoferson John S · Denton, TXBuilt 1988 · S/N 4608122 N42BELasalle Management Company LLC · Ruston, LAS/N 3903 N42BWHci Real Estate II LLC · Granbury, TXBuilt 2022 · S/N 8754 N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228 N42EMNbc Sales LLC · Somerville, TNBuilt 1967 · S/N 18258542 N42ESTree Tangos LLC · Nashville, TNBuilt 2019 · S/N 1985 N42GMNelson Gale M Trustee · Spokane, WABuilt 1954 · S/N 23316 N42HFKlochko Oleg Alexander · Furlong, PABuilt 1974 · S/N TC-1730 N42HHHageness Donna L · Rolette, NDBuilt 1977 · S/N 34-7770093 N42JVCheshire Vincent Eugene Jr · Slidell, LABuilt 1980 · S/N CE-913 N42JWBusiness Aircraft Leasing Inc · Petersburg, ILBuilt 1965 · S/N TC-884 N42KCChatham Kenneth W · Montross, VABuilt 1968 · S/N 18259044 N42KWMarine Aviation LLC · Lyme, NHBuilt 2001 · S/N TH-1985 N42LBRigney Timothy D · Troy, VABuilt 1970 · S/N D-9140 N42LCFly To Ski LLC · Avalon, NJBuilt 2025 · S/N 10684 N42MDN42md LLC · Ashburn, VABuilt 1999 · S/N 29-0178 N42MMPiper Capital LLC · Elkhorn, NEBuilt 1988 · S/N CE-1278 N42MWWalker Winston W Trustee · Tucson, AZBuilt 1981 · S/N 414A0680 N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387 N42PGWright Charles E · Hebron, KYBuilt 1977 · S/N 28R-7703353 N42PJCapital Business Forms Inc · San Bernardino, CANon-citizen corporation, flight hours not reportedBuilt 2008 · S/N 31-0116 N42PYArtemis Aviation LLC · Houston, TXBuilt 2022 · S/N 8941 N42QAAvisaga LLC · San Jose, CABuilt 2023 · S/N 9598 N42RHGet-U-There Air LLC · Poplar Grove, ILBuilt 1979 · S/N 18266776 N42SGPolar Star Co · Wilmington, DES/N 4140927 N42SHLejoran LLC · San Mateo, CABuilt 2024 · S/N 10066 N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109 N42SSBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 310Q0682 N42SWHolt Aviation LLC · Clear Lake, IABuilt 1957 · S/N 144003 N42TBFlores Nicholas L Jr · San Antonio, TXBuilt 1998 · S/N TH-1872 N42TJShark Vision LLC · Palm Harbor, FLBuilt 2017 · S/N 4507 N42TNCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11521 N42TVK2 Aviation LLC · Carroll, IABuilt 1998 · S/N 29-0168 N42TXWu Tang Aviation LLC · Queen Creek, AZBuilt 2012 · S/N 0297 N42VRBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1673 N42VXJjl Aviation LLC · Springville, IABuilt 2022 · S/N 9025 N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667 N42WDN42wd LLC · Seattle, WABuilt 1972 · S/N 18261403 N42WGEl Paso Industries Inc · Santa Teresa, NMBuilt 1969 · S/N 18259414 N42WKMariash Cary Norman · Indianapolis, INBuilt 1964 · S/N D-7390 N42WSOrlandella Vito · Auberry, CABuilt 1955 · S/N 35143 N42WWZahler Mitchell J · Stillwater, MNS/N 3688 N42ZBMelbourne Aviation LLC · Melbourne Beach, FLBuilt 2016 · S/N 1449 N42ZNHuntsville Flyers LLC · Owens Cross Roads, ALBuilt 2001 · S/N 0042 N4300QFarwell Christopher J Trustee · Olympia, WABuilt 1973 · S/N 18502232

Back to AD 2000-23-21