Registered aircraft · 47,133

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.

N403MCHuntington Aviation LLC · Irving, TXBuilt 2009 · S/N 411135 N403PKN403pk LLC · Ada, MIBuilt 1977 · S/N 18265475 N403PLAircraft Partners LLC · Tampa, FLBuilt 2014 · S/N 0860 N403PTProvo Cirrus LLC · Provo, UTBuilt 2007 · S/N 2404 N403RMUlpiano Amy L · Carolina, PRS/N 402B0836 N403SWheeler James · Shreveport, LABuilt 1980 · S/N P21000403 N403SACalk Mark C · Troy, ALBuilt 2001 · S/N E-3407 N4041HInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 25-0396 N4042ARogden Aviation Inc · San Rafael, CABuilt 1970 · S/N D-9102 N4043AByard Jeffrey G · Carson City, NVBuilt 1970 · S/N D-9103 N4043GGalaxy Aviation Services LLC · Orlando, FLBuilt 1977 · S/N 340A0266 N4043KJackson Ian C · Rochester, NHBuilt 1949 · S/N NAV-4-1043 N40441Dozier Todd A · Fairfax Station, VAS/N 28R-7703306 N4045AWdw Aviation Leasing Inc · Knoxville, TNBuilt 1970 · S/N D-9104 N4045DTlm Properties LLC · Gladewater, TXBuilt 1957 · S/N 34745 N4046BWildeson Dwight L · Troutdale, ORS/N 75-30788 N4047DEiff John E · Deland, FLFirst renewal noticeBuilt 1957 · S/N 34747 N40484Sunland Air Inc · Frederick, MDBuilt 1973 · S/N 310Q-0735 N4048MJoel Massey Real Estate LLC · Flowery Branch, GABuilt 1981 · S/N 182-67993 N4049DUnwrapped LLC · Dover, DEBuilt 1957 · S/N 34749 N404BNCienski Todd A · Duncanville, TXBuilt 1965 · S/N 21058705 N404BTMosaid Aviation LLC · Copperopolis, CABuilt 2024 · S/N 10258 N404CPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 404-0238 N404CYWilkinson Aviation LLC · Wilmington, DEBuilt 2014 · S/N E-4040 N404DGSubgup LLC · Naples, FLS/N 414A0111 N404JALamoreaux Gene H Trustee · Mckinney, TXBuilt 2008 · S/N 411093 N404LFHicks Michael P Jr · Wallis, TXBuilt 1974 · S/N E-588 N404MDDent Thomas E · Moses Lake, WABuilt 1964 · S/N D-7437 N404MJParadise Boating Co · Chicago, ILBuilt 2008 · S/N 411074 N404NSJ + D Aviation Services LLC · Centerville, MABuilt 1980 · S/N 402C0421 N404PJPrivate Jet LLC · Miami Springs, FLBuilt 1981 · S/N 402C0513 N404RGJoyner James M · Eagle River, AKS/N 18502702 N404SBIntegra Equipment LLC · Payson, AZBuilt 2025 · S/N 10404 N404SGColon Aviation LLC · Greenville, SCBuilt 2021 · S/N 5036 N404SMForm 50 Aviation LLC · Newark, DEBuilt 1966 · S/N 18257374 N404TLBrock Christopher H · Roswell, GABuilt 2004 · S/N 3RX125 N404VDevine Timothy P · Roseville, CABuilt 1962 · S/N D-6981 N404WMArmbruster LLC · Amherst, OHS/N 29-0067 N404YGAviation Trust Company LLC · Oklahoma City, OKBuilt 1998 · S/N LIV 322 N4050DKesling Aviation LLC · Orange Beach, ALBuilt 1957 · S/N 34750 N4051CSky High Ventures LLC · Bartlett, TNBuilt 1980 · S/N 340A0995 N4051DOlson Scott L · Girdwood, AKS/N 34751 N4052BHatter Ronnie · Newcastle, OKBuilt 1976 · S/N 76-30813 N4053BCavenagh Thomas D · Lawton, OKBuilt 1975 · S/N 76-30797 N4053DGardner Dale R · North Logan, UTBuilt 1957 · S/N 34753 N4054BKing Ronald S Jr · Goldsby, OKBuilt 1976 · S/N 76-30831 N4054DBass Edward J · Richland, WABuilt 1958 · S/N 34754 N4055DLoup Technologies Inc · Longmont, COBuilt 1957 · S/N 34755 N4056SAvery Judy J Executor · Plainfield, ILBuilt 1974 · S/N E-617 N4057BKaler Wayne J · Sayville, NYBuilt 1974 · S/N 75-30739

Back to AD 2000-23-21