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.

N327ZDaj Aviation LLC · Manvel, TXBuilt 1960 · S/N CD-224 N32806Nimsic Thomas L · Carson City, NVBuilt 1976 · S/N 18264943 N3280XCoastal Defense Inc · Mill Hall, PABuilt 1967 · S/N 310L-0130 N32812Rottinghaus Kelly A · Dundee, MSS/N 34-7570056 N3281DRichardson John David · Willis, TXBuilt 1955 · S/N 32079 N3281KWallace Architects LLC · Columbia, MOBuilt 1979 · S/N TH-1006 N3281SWright Flyers Club · Huber Heights, OHBuilt 1964 · S/N 18255781 N3282DLafleur Kerry P · Fort Worth, TXBuilt 1955 · S/N 32080 N3282SWest Thomas Edward · Watsonville, CABuilt 1964 · S/N 18255782 N3283DAllen Roger B · Gardnerville, NVBuilt 1955 · S/N 32081 N3284DKornfield Edward A · Anchorage, AKBuilt 1955 · S/N 32082 N3284YMonnin Cass C · East Wenatchee, WAS/N 18254284 N3285SCastro Manny H · Tucson, AZBuilt 1964 · S/N 18255785 N3285VAviate Navigate Communicate LLC · Dewey, AZBuilt 1977 · S/N R1722245 N32863International Air Services Inc Trustee · Carson City, NVS/N 34-7570062 N32873Blundell Joseph B III · Belleville, ARBuilt 1975 · S/N 34-7570064 N3288DSmith James O · Montgomery, TXS/N 32086 N3288MClute Kenneth N · Las Vegas, NVBuilt 1980 · S/N 310R1895 N3288SEpple William E · Roggen, COBuilt 1964 · S/N 18255788 N3288UVetch Rod F · Ranchester, WYBuilt 1963 · S/N 18254688 N3289SDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 18255789 N3289URutenbeck Terry L · Wiggins, COBuilt 1963 · S/N 18254689 N3289YHasselbring Ted S · Nashville, TNBuilt 1962 · S/N 18254289 N328BNothing Wasted LLC · Bunker Hill, INBuilt 1966 · S/N D-8307 N328CPX Aviation LLC · Brooksville, FLBuilt 2008 · S/N 3248 N328CSJskld LLC · Lexington, KYS/N T24002098 N328CWBulldog Aviation LLC · Charleston, SCBuilt 2025 · S/N 11087 N328DATfo Aircraft LLC · West Chester, PABuilt 2022 · S/N 8534 N328DJAltru Diagnostics · Houston, TXBuilt 2023 · S/N 9585 N328DKHigh Flight Adventures LLC · Ogden, UTBuilt 2006 · S/N 1749 N328EMConcierge Diamonds Inc · Los Angeles, CABuilt 1985 · S/N 46-8508087 N328HRShuster David · Fredericksburg, VABuilt 1979 · S/N D-10269 N328JWL & R Cirrus Inc · Portage, PABuilt 2002 · S/N 0225 N328LDuffield Brian · Eastvale, CABuilt 1973 · S/N 18262043 N328LJYouderian Construction Inc · Stanford, MTBuilt 2023 · S/N 9197 N328MN328m LLC · Marion, INBuilt 2001 · S/N TH-1992 N328MBN328mb LLC · Old Bridge, NJBuilt 2004 · S/N 0867 N328MCHelix Aviation LLC · Bar Harbor, MEBuilt 2017 · S/N 1513 N328PStrother J Barron · Santa Rosa Beach, FLBuilt 1999 · S/N TH-1916 N328PMMayworm Patrick · Mclean, VABuilt 2022 · S/N 3RX116 N328RHEchemendia Joel · Kissimmee, FLBuilt 2004 · S/N 1008 N328SFast Flight Inc · Springdale, ARBuilt 1969 · S/N D-9068 N328SRStarr Robert J · Burlington, VTBuilt 2007 · S/N 2516 N328TJTasker Jerome · Midland, GABuilt 2005 · S/N 41524 N328WHLegends Air Center LLC · Bentonville, ARBuilt 2013 · S/N 0547 N328ZPellicone Scott V · Millstone Township, NJBuilt 1960 · S/N CD-226 N32909Zamarripa Hector · Brownsville, TXBuilt 1970 · S/N 18260423 N3290FCline Mark A · Winston Salem, NCBuilt 1967 · S/N R172-0222 N3290XBirman Pablo E · Suamico, WIBuilt 1967 · S/N 310L-0140 N3291SRegistration Pending · Highland, ILRegistration pendingBuilt 1964 · S/N 18255791

Back to AD 2000-23-21