Registered aircraft · 81,728

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N321KJFly-By LLC · Cope, COBuilt 2022 · S/N 12190081 N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853 N321LALowair LLC · Lake City, SCBuilt 1978 · S/N 32R-7885178 N321LMStarkey Mike · Dayton, NVBuilt 2021 · S/N 12180029 N321MECounty Of Henrico Virginia · Henrico, VABuilt 2000 · S/N 172S8566 N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850 N321MLSalerno Lawrence B · St Charles, ILBuilt 1991 · S/N 1042 N321MPAker Carroll Gregory · Titusville, FLBuilt 1991 · S/N 10084 N321NASanchez David A · San Luis Obispo, CABuilt 2001 · S/N 24650 N321NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881748 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N321PFRrsf LLC · Pleasant Grove, UTBuilt 2004 · S/N 40.375 N321PKYaqunda Yousif N · Fallbrook, CABuilt 1994 · S/N PK-1 N321PRChavi LLC · Fredericksburg, TXBuilt 2006 · S/N 11142 N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438 N321RCHitchen Robin J · Bernardsville, NJBuilt 2013 · S/N 90217 N321RJGritter Richard J · Catlett, VABuilt 1977 · S/N 323-77 N321RTBarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 189 N321RVRegistration Pending · Norton Shores, MIRegistration pendingBuilt 1998 · S/N 20372 N321SASedlak Julien · Fort Worth, TXBuilt 1993 · S/N 1251 N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333 N321SKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2019 · S/N 30050 N321SREstler Carlton George · Richmond, TXBuilt 1995 · S/N 3239 N321TBradshaw & Company Insurors · Dyersburg, TNBuilt 1953 · S/N 18-2435 N321TAAldag Thomas D · Wichita, KSBuilt 2020 · S/N 83171 N321TDDeakyne David J · Wallingford, PABuilt 1992 · S/N DEAKYNE 0001 N321TEBerg Orvie E Trustee · Rock Springs, WYBuilt 2001 · S/N 32 N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807 N321VAvia Flight Academy LLC · Stratford, CTBuilt 1968 · S/N 28-4665 N321VBYoung Mike · Loop, TXBuilt 1960 · S/N 18-7533 N321VESullivan Mike D · Braddyville, IABuilt 1995 · S/N DMO243 N321VGGemmiti Vincent M Jr · Cabot, ARBuilt 1997 · S/N 16 N321VTWinick Scott · Jay, VTBuilt 1973 · S/N 507 N321WFWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17280987 N321WSWrong Brothers Aviation LLC · Wilmington, DEBuilt 1973 · S/N AA5-0327 N321YZStroh Michael · Killdeer, NDS/N 28-7505039 N32200Owsley Kevin · Auburn, ALBuilt 1974 · S/N 28-7525036 N32204Flying Country Club Inc · Coal Valley, ILBuilt 1974 · S/N 28-7515094 N32206Williams Jonathan · Meadow, TXBuilt 1974 · S/N 28-7515097 N32207Petersen David A · Soldotna, AKBuilt 1947 · S/N 7856 N32209Mitchellville Flyers Inc · Annapolis, MDBuilt 1974 · S/N 28-7505037 N3220WBarnes Matthew Thomas · Valdosta, GABuilt 1965 · S/N 32-25 N32210Steiner Hans L · Exeter, CABuilt 1954 · S/N 7859 N3221WRay Troy D · Roanoke, VAFirst renewal noticeBuilt 1965 · S/N 32-27 N32223Boehm William Dean · Baldwin, ILS/N 28-7515101 N32225Tranby Todd · Minot, NDS/N 7874 N32228Segalla Susan B Trustee · Venice, FLBuilt 1974 · S/N 28-7505040 N3222MRegistered aircraftBuilt 1947 · S/N 12-1887 N3222ZBoggs Anthony M · Pringle, SDBuilt 1959 · S/N 22-7163 N32230Chadwick Parker · Townsend, MTBuilt 1952 · S/N 18-88

Back to AD 81-18-04 R2