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.

N313EZFlightwerks LLC · Commerce Township, MIBuilt 2022 · S/N 8957 N313FFerguson John Edward · Santa Ysabel, CABuilt 1958 · S/N D-5764 N313GCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11547 N313GBBurnett Gregory C · Rogersville, MOBuilt 1977 · S/N 21061986 N313GMEugene C Warne Trustee · Alamo, CABuilt 2009 · S/N E-3907 N313GPGeiger Aviation LLC · Mount Pleasant, SCBuilt 2017 · S/N 1478 N313JBConchy Joe Aviation LLC · Fort Lauderdale, FLBuilt 2017 · S/N 1631 N313JHJam Three LLC · St George, UTBuilt 1974 · S/N 310Q1011 N313JWWright George E Jr · Homestead, FLBuilt 1971 · S/N 18260706 N313KGJj Aviation Holdings LLC · Raleigh, NCBuilt 2025 · S/N 10572 N313LCShort Carl R · Issaquah, WABuilt 2008 · S/N 3046 N313MBosco74 LLC · Wilmington, DEBuilt 1963 · S/N 500A-1276-99 N313MEBasille Vision LLC · Lewes, DEBuilt 2021 · S/N 2443 N313MHHarder-Diesslin Development Group LLC · Salida, COBuilt 2010 · S/N 3619 N313MLAir Mer LLC · Los Altos, CABuilt 2017 · S/N 1613 N313MPAlpha Bravo Charlie 1 Corp · Houston, TXBuilt 1980 · S/N P21000573 N313NRDawn Patrol LLC · Portsmouth, NHBuilt 2024 · S/N 10209 N313RJNew Hampshire Flying Association Inc · Nashua, NHS/N CE-911 N313RWSarp Rentals LLC · Loudon, TNBuilt 1969 · S/N 414-0010 N313SCCirrus N7580 LLC · Valparaiso, INBuilt 2024 · S/N 10122 N313SKJohnson Scott · Blaine, MNBuilt 1973 · S/N 18262630 N313SRTrust Your Fronts LLC · Miami, OKBuilt 2006 · S/N 1978 N313TF313tf Aviation LLC · Superior, WIBuilt 2004 · S/N 1237 N313TLSmallwood Aviation LLC · Nokesville, VABuilt 2024 · S/N 9965 N313TNSouthern Comfort Horizons LLC · Naples, FLBuilt 2006 · S/N 31-0003 N313VBVernor Air LLC · Harbor Springs, MIBuilt 2016 · S/N 4361 N313VFRegistered aircraftBuilt 2025 · S/N 10405 N313WWilliams Thomas James · Clovis, CABuilt 1981 · S/N D-10363 N313WTCinotto Robert L · Rhome, TXBuilt 1979 · S/N P21000350 N3140CAthens William A · Missoula, MTBuilt 1954 · S/N 30939 N3140FWilliams Thomas G · Richland Center, WIBuilt 1966 · S/N 18257240 N3140SLavell Michael J · Blue Mounds, WIS/N 18255640 N3140YParker Mccrum LLC · Eugene, ORBuilt 1962 · S/N 18254140 N31416Pterosaur Holdings LLC · Scarsdale, NYBuilt 2018 · S/N 4665 N3141DNelson Donald W · Aurora, COBuilt 1955 · S/N 31939 N3141FDoerr John · Sandy, ORBuilt 1966 · S/N 18257241 N3141RIncze Bela · Morgan Hill, CABuilt 1967 · S/N 18258541 N3141SValley Excavation And Grading Inc · Chatsworth, CABuilt 1964 · S/N 18255641 N3141UMo2 Investing LLC · Springfield, MOS/N 18254541 N3142CItm Electronics Inc · Greenleaf, IDBuilt 1954 · S/N 30941 N3142QRogers James · Summerfield, FLBuilt 1967 · S/N 18258142 N3142SB&G Aircraft LLC · Greensboro, GABuilt 1964 · S/N 18255642 N3142YOdom Aviation Inc · Cabot, ARS/N 18254142 N3143QJlm Management LLC · Clarion, PABuilt 1967 · S/N 18258143 N3143RNelson John J · Salmon, IDBuilt 1967 · S/N 18258543 N3143UTimuuu Inc · Alden, NYBuilt 1963 · S/N 18254543 N31444Crossen John R · San Pedro, CABuilt 1988 · S/N CE-1277 N3144HT And C Corp · Wilmington, DEFirst renewal noticeBuilt 1987 · S/N CE-1191 N3144MWhite Ice Holdings LLC · Santa Rosa Beach, FLBuilt 1987 · S/N CE-1206 N3144QRichmond Brian · Rhome, TXBuilt 1967 · S/N 18258144

Back to AD 2000-23-21