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.

N2155NFlight Test Affiliates LLC · Flagler Beach, FLBuilt 1981 · S/N EA-255 N2155ROne Zero Four LLC · Germantown, TNBuilt 1964 · S/N 18255355 N2155WHansen Edward J · Fairfield, CTBuilt 1997 · S/N 25-2010 N21562Blevins Michael W · Sayre, OKBuilt 1973 · S/N 18261715 N21566Brenner Gerald Benjamin · Oxford, MDBuilt 1973 · S/N 18261718 N2156GBenson John Wesley Jr · Tecumseh, MIBuilt 1958 · S/N 51456 N2156RWinfrey Walter A Trustee · Auburn, CABuilt 1964 · S/N 18255356 N2157GAviation Bravo Corporation LLC · Palm Coast, FLFirst renewal noticeBuilt 1958 · S/N 51457 N2157MTrejo Haitlay · Socorro, TXBuilt 1979 · S/N 28R-7931042 N2157SSchlenker Wesley E · Dallas, TXBuilt 1975 · S/N 21061118 N2157ZHamel Ryan Alan · Klamath Falls, ORBuilt 1963 · S/N 18051257 N21581Skyline Aviation Inc · Racine, WIFirst renewal noticeBuilt 1943 · S/N 18261729 N21587B & D Fuel Injection Service Inc · Rhoadesville, VABuilt 1973 · S/N 18261733 N2158JMccormick Eugene C DBA · Tyler, ALBuilt 1979 · S/N T18803395T N2158N2th Aviation LLC · Johnson City, TNBuilt 1998 · S/N 29-0167 N2158VDe Sousa Jorge Norberto Freitas · Cape Coral, FLBuilt 1978 · S/N 28R-7803151 N21593Peyt Rentals LLC · Cobb, GABuilt 1973 · S/N 18261739 N21597Gsw Flyers LLC · Pittstown, NJBuilt 1973 · S/N 18261741 N21598Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1973 · S/N 18261742 N2159ER & S Investment Partners LLC · Kennesaw, GABuilt 2000 · S/N 29-0238 N2159GKirchoff Kevin B · Millington, TNS/N 51459 N2159LMark A Smith Airplane Sales Inc · Homosassa, FLBuilt 1976 · S/N E-902 N2159SOutfront Aviation LLC · Merritt Island, FLBuilt 1979 · S/N 34-7970144 N215AMurphy Dan A · Two Harbors, MNBuilt 1954 · S/N 35013 N215AEN215ae LLC · Dover, DEBuilt 2026 · S/N 11463 N215ALUdaan LLC · Vienna, VABuilt 2025 · S/N 11061 N215BFWiederhoeft Dustin L · Fairmont, MNBuilt 1964 · S/N D-7665 N215CBKw Bradley Associates LLC · Manlius, NYBuilt 1980 · S/N 340A1019 N215CHKld Air LLC · Charlotte, NCBuilt 1977 · S/N TE-1116 N215CPMcallen Enterprises LLC · Mission, TXBuilt 2006 · S/N 1741 N215CTTellam Allan R Trustee · Chandler, AZS/N 41646 N215EBSalty Air LLC · Wayne, PABuilt 2024 · S/N 9766 N215EMPostma Air LLC · Saint Paul, MNS/N 2453 N215EVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 348533002 N215FJOzark Machinery Transportation LLC · West Plains, MOBuilt 2018 · S/N 1742 N215GNBbt Jewelry LLC · Miami, FLS/N P21000335 N215GPPoint To Point LLC · Missoula, MTBuilt 2012 · S/N 0331 N215GTInsulation By Cohens LLC · Moncks Corner, SCS/N TH-2439 N215JInnovative Aerodynamic Technologies · Yorktown, VAS/N 21059226 N215JGClower Aviation LLC · Owasso, OKBuilt 2013 · S/N 0486 N215JPPilot Peak Adventures LLC · Ely, NVBuilt 2007 · S/N 2493 N215LLNorthern Colorado Capital Holdings LLC · Timnath, COBuilt 2010 · S/N LS227 N215NCDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N E-3444 N215PDube William E Jr · Prescott, AZBuilt 1992 · S/N CE-1676 N215QSooter Craig A · Sedgwick, KSS/N D-7600 N215RGGonzalez Rogiero A · San Antonio, TXBuilt 1979 · S/N 18266883 N215RMKevin W Singletary & Associates LLC · Little River, SCBuilt 1977 · S/N 28R-7703219 N215RRRednor Jeffrey · Yardley, PABuilt 2005 · S/N 1448 N215RWUnderwood Darin M · Cedar Rapids, IABuilt 1995 · S/N E-2965 N215SRDkm Aviation LLC · Dawsonville, GABuilt 2006 · S/N 1680

Back to AD 2000-23-21