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.

N391ERegistration Pending · Dodge City, KSRegistration pendingBuilt 1960 · S/N 39131 N391PT7640 Drilling LLC · Amarillo, TXBuilt 1973 · S/N 21060097 N391SAndrews Patrick D · Neosho, MOBuilt 1970 · S/N TC-1095 N391SCSkydive Pennsylvania Inc · Mercer, PABuilt 1969 · S/N U2061405 N391XSullinger Billy · Pocahontas, ARBuilt 1976 · S/N 6183C N391ZKeene Keith · Houston, TXBuilt 1960 · S/N D-6558 N3921YThompson Steven J · Royse City, TXBuilt 1964 · S/N 21058421 N3923GMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0923 N39252Wildgen Harry J · Ashland, ORBuilt 1989 · S/N 25-1200 N3925YAbney Timothy D · Powell, OHS/N 21058425 N3927DRi Skydiving Aircraft LLC · Middletown, RIBuilt 1957 · S/N 34627 N3927GAerial Transport LLC · Dover, DEBuilt 1967 · S/N U206-0927 N3927MTulin Donald J · Anchorage, AKS/N U20604423 N3927YMackenzie Stuart D · Pearland, TXBuilt 1964 · S/N 21058427 N3928BKellner Eric · Upland, CABuilt 2004 · S/N 0917 N3928DGallatin 182a Flyers LLC · Bozeman, MTBuilt 1957 · S/N 34628 N3928MSalter James A · San Luis Obispo, CABuilt 1978 · S/N 28R-7803201 N3928VThompson Edmond P · Langley, WABuilt 1977 · S/N R1722267 N3929YAinsworth Ryan · Portales, NMBuilt 1964 · S/N 21058429 N392BBowling Gregory · Floresville, TXBuilt 1957 · S/N D-5282 N392MTOld School Consulting And Management LLC · Henderson, TXBuilt 2018 · S/N 1772 N392PTCadd James · Burlington, WIBuilt 1958 · S/N 50140 N392SPlocher Corey · Port Orchard, WABuilt 1968 · S/N D-8752 N392ZGen Av Resources Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1960 · S/N CD-265 N3930DColovich Barry L · Vernal, UTFirst renewal noticeS/N 34630 N3930XWilson Martin E · Arlee, MTBuilt 1975 · S/N 34-7570317 N3931DTolman Cory A · Fallon, NVBuilt 1957 · S/N 34631 N3932ASims Douglas · Naples, FLBuilt 1953 · S/N 53-4117A N3934BMahoney Andrew R · Fairbanks, AKBuilt 1954 · S/N 30148 N3935DHudson Jon P · Bozeman, MTBuilt 1957 · S/N 34635 N3936GBaker George G · Junction City, ORBuilt 1976 · S/N 340A0237 N39393International Air Services Inc Trustee · Carson City, NVS/N 3449485 N3939DRed Baron LLC · Middletown, DEBuilt 1957 · S/N 34639 N3939GThree Niner Gulf L L C · Denver, COBuilt 1967 · S/N U206-0939 N393BThickstun Benjamin Tyler · Wasilla, AKBuilt 1973 · S/N 18052299 N393CA2050 Services LLC · Burlington, WIBuilt 2001 · S/N 172S8983 N393CDBowtie Properties LLC · Dadeville, ALBuilt 2005 · S/N 1478 N393CPN393cp LLC · Manteca, CABuilt 2008 · S/N 1924 N393DSRut N Strut Aviation LLC · Shelbyville, KYBuilt 2023 · S/N 9499 N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261 N393FBRegistered aircraftBuilt 2002 · S/N TH-2026 N393GMFly Illini LLC · Indianapolis, INBuilt 2017 · S/N 4474 N393JM3b Family LLC · Dover, DEBuilt 2015 · S/N 4287 N393MUsda Forest Service Fepp · Helena, MTBuilt 1964 · S/N 185-0684 N393PSVein C Jason · Riviera Beach, FLBuilt 2005 · S/N 29-0393 N393SRColbyco Jet Management LLC · Keller, TXBuilt 2006 · S/N 31-0008 N393TIronhawk Aviation LLC · Indianapolis, INBuilt 1963 · S/N D-7166 N3941DOrchid Aero LLC · Lakewood, COBuilt 1957 · S/N 34641 N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442 N3943DLoudan Christopher D · Trinidad, TXBuilt 1957 · S/N 34643

Back to AD 2000-23-21