OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,131

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
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.

N104SVCrete Solutions LLC · Wilmington, NCBuilt 2025 · S/N 11053N104TQGtw Aviation LLC · San Jose, CABuilt 2006 · S/N 2304N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301N104WWJarosak Peter J · Valparaiso, INBuilt 1981 · S/N E-1889N10502Flying Chipmunk LLC · Charlotte, NCBuilt 2025 · S/N 10502N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707N1050TThrash Scott · Hesston, KSBuilt 1976 · S/N E-881N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966N1051KMcclure Paul D · Birmingham, ALBuilt 2002 · S/N 29-0285N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421N1052AKraken Aviation LLC · Camden, DEBuilt 2016 · S/N 1333N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709N1052MFendt Alan D Trustee · Dexter, MIBuilt 1975 · S/N 18264216N1052QNighthawk Air Systems Inc · Miami, FLS/N 310H0052N1053LKutzleb Michael K · Fernandina Beach, FLBuilt 2000 · S/N 29-0261N1054CCumberland Curtis · Union Bridge, MDBuilt 2003 · S/N 29-0296N1054KBondy William G · Miami Beach, FLBuilt 2000 · S/N 29-0266N1054VNorthington Neill · Fredericksburg, TXBuilt 1976 · S/N R1722094N1054WHeavers George S · Oakland, CABuilt 1973 · S/N TH-312N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195N10554T34sum LLC · Lake In The Hills, ILS/N CCF-34-37N1055MRyan Michael W · Long Beach, CABuilt 1975 · S/N 18264217N1055VWarner Alan P · Carpinteria, CABuilt 1976 · S/N R1722095N1056FBrasil John I · Lemon Grove, CABuilt 1975 · S/N 18502712N1056QAerotrack Inc · Hemet, CABuilt 1963 · S/N 310H0056N1056TTierno Patrick Louis · Seaford, DES/N 30-0065N1057WMaisano Abby · Hendersonville, TNBuilt 1973 · S/N E-408N10580Dwyer Lawrence William · Berthoud, COFirst renewal noticeS/N 411150N1058RWindle Air Baron LLC · Lynchburg, VABuilt 1996 · S/N TH-1791N1058VPelfrey Earl T · Crossville, TNBuilt 1976 · S/N R1722097N1058ZBaillie Richard Leslie · Newark, DEBuilt 2008 · S/N 411058N105BCKlauber Robert A · Athens, TNBuilt 1966 · S/N 310K0232N105CKHdm Aviation LLC · Saratoga, CABuilt 2016 · S/N 4399N105CWStone George Michael Jr Trustee · Weeki Wachee, FLBuilt 1974 · S/N 310Q-0936N105DFWestwood Aero Inc · Porterville, CABuilt 1986 · S/N 21064999N105FADebbie Air LLC · Perkasie, PABuilt 1965 · S/N CD-853N105GCCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 11013N105HCJi Aviation LLC · Vidalia, LABuilt 2019 · S/N 4777N105KAGillespie Todd · Trenton, SCS/N 401-0238N105KLWing It LLC · Madison, WIBuilt 2017 · S/N 4461N105LRegistered aircraftBuilt 1959 · S/N 35981N105LWCan You See Me Now LLC · Dakota Dunes, SDBuilt 2024 · S/N 9852N105MCMathison John M · Del Norte, COBuilt 1964 · S/N 310I0162N105MTRegistered aircraftBuilt 1976 · S/N 182-64338N105PAPeck John A Jr · Shady Shores, TXBuilt 1997 · S/N 29-0107N105PKMendel Aviation LLC · Albuquerque, NMBuilt 2023 · S/N 9235N105PZPca Leasing LLC · Heber City, UTBuilt 2009 · S/N L2K-295
Back to AD 2000-23-21