Registered aircraft · 47,142

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.

N1127RSwan Aviation LLC · Columbia Heights, MNBuilt 2005 · S/N 1510 N1128CGibbs Wyatt R · Lodi, CABuilt 1978 · S/N 21062711 N1128RPeninsula Research LLC · San Carlos, CABuilt 2021 · S/N 2338 N1128TMccauley Mcdonald Investments Inc · Eastover, NCBuilt 1996 · S/N E-3028 N1129LFlyclem LLC · Brooklyn, NYBuilt 2008 · S/N 31-0078 N1129QTippecanoe Valley Aero Inc · Delphi, INBuilt 1963 · S/N 310H0129 N1129SGarmin International Inc · Olathe, KSBuilt 1997 · S/N TH-1812 N1129TStapleton Thomas · Avon, INBuilt 1976 · S/N D-9867 N1129WSilver Wing Aviation LLC · Wilmington, DEBuilt 1997 · S/N TH-1809 N112ACJones Michael · Freeport, TXBuilt 1964 · S/N TC-681 N112BBNethery Cattle Co LLC · Fort Worth, TXBuilt 2018 · S/N E-4112 N112CAWickter Lawrence D Jr · Sugar Grove, ILBuilt 1972 · S/N 23 N112CDRustam Ali Wings Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11457 N112DKHolmes Lynne · Lenoir City, TNBuilt 1980 · S/N CE-904 N112EReed Gaylon R · Breckenridge, TXBuilt 2012 · S/N E-3980 N112EWKerwin Patrick C · Redwood City, CABuilt 1974 · S/N 21060504 N112FSFl Co-Owners #1 LLC · Roseville, CABuilt 2023 · S/N 9497 N112GBN112gb LLC · Oldsmar, FLBuilt 1964 · S/N CD796 N112GCSkywagon Ventures LLC · Chapel Hill, NCBuilt 1973 · S/N 18052387 N112HBenschoter Cameron · Bonifay, FLS/N TC-722 N112HPBertagnole Karl R · Wright, WYFirst renewal noticeBuilt 1964 · S/N 310I0104 N112HRFlexer Howard · Monterey Park, CAS/N 35217 N112KDCloud Surfing LLC · Mesa, AZBuilt 2016 · S/N E-4076 N112LFBeachcomber Run LLC · Winston Salem, NCBuilt 2016 · S/N 1393 N112LJJohnson Lenny · Baton Rouge, LABuilt 2024 · S/N 10353 N112MCForgotten Heroes Foundation Inc · Chesapeake, VABuilt 1951 · S/N 21071 N112MHJsi Contractors Inc · San Antonio, TXBuilt 1980 · S/N E-1659 N112MKTen Lakes Holdings LLC · Eureka, MTBuilt 2023 · S/N 9282 N112NL1st American Aviation Inc · North Miami, FLS/N 18258322 N112NRTkg Aviation LLC · Denver, COBuilt 2011 · S/N 0227 N112PCTaylor Bradley S · Abilene, TXBuilt 1976 · S/N TH-720 N112PJHappy Trailer Sales LLC · Palmer, TXBuilt 2017 · S/N 1540 N112RCStraubel Investments Inc · Egg Harbor, WIBuilt 1973 · S/N 79 N112SPowell Paul L · Rancho Cucamonga, CABuilt 1964 · S/N D-7466 N112SKCirrus Sr22 4821 Inc Trustee · Wilmington, DEBuilt 2019 · S/N 4821 N112SSOlsen John · Wasilla, AKS/N 18052510 N112TDBigsky 157 LLC · Missoula, MTBuilt 2025 · S/N 10470 N112TRBagdasarian Walter DBA · El Cajon, CABuilt 2010 · S/N 3669 N112VBHatley Ralph A · Eagle Creek, ORBuilt 1963 · S/N 18254937 N112WGGriswold Aviation LLC · San Clemente, CABuilt 2024 · S/N 9785 N112WWAmerican Smooth Aviation LLC · Rock Hill, SCFirst renewal noticeBuilt 1977 · S/N 310R1215 N112XAir Corriente LLC · Columbia, TNBuilt 1966 · S/N D-8121 N1130MTelbo LLC · Vonore, TNBuilt 1965 · S/N D-8023 N1130QHedges William S · Algona, IABuilt 1997 · S/N EA-598 N11312Clarity Aviation LLC · Anchorage, AKS/N 1021 N1131MWhite Tom · South Charleston, WVBuilt 1975 · S/N 18264228 N1131QFarm Country Air LLC · Jefferson, IABuilt 1977 · S/N 28R-7703053 N1131VPeter V Desanctis Cpa Pa · Jupiter, FLBuilt 2008 · S/N 411098 N1131WPrice Steven D · Healdsburg, CABuilt 1976 · S/N 18264584 N1132TPeck Russell C · Memphis, TNBuilt 1976 · S/N TC-1962

Back to AD 2000-23-21