Registered aircraft · 4,001

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-13-10-R1') 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-13-10-R1') 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-13-10-R1')
    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-13-10-R1')
  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-13-10-R1')
  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-13-10-R1')
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.

N310FWWyslup Natascha Bristi · FrankfurtammainBuilt 1981 · S/N 25-0611 N31110Anica Properties LLC · Chandler, AZBuilt 2005 · S/N 3449319 N311FWAmdel Holding LLC · Houston, TXBuilt 1981 · S/N 25-0612 N311JSouthwest Aircraft LLC · Fairacres, NMBuilt 1967 · S/N 67-21311 N311MAWilkins Ralph Steven · Guymon, OKBuilt 1997 · S/N 25-2011 N311PCBonacci Thomas M · Salt Lake City, UTBuilt 1979 · S/N 25-0194 N312ABSmith Kenneth R · Senoia, GAFirst renewal noticeBuilt 1978 · S/N 28R-7803120 N312CNN312cn LLC · Prescott, AZBuilt 1980 · S/N 28R-8031023 N312TJRau John M · S Coffeyville, OKS/N 023 N3134VShelley Cameron M · Reno, NVS/N R1722240 N31386S&L Aircraft LLC · Port Trevorton, PABuilt 1978 · S/N 28R-7837233 N3139VArrow Trading Inc · Coconut Creek, FLBuilt 1977 · S/N R1722241 N313ASStephen Air LLC · Woodsfield, OHBuilt 1980 · S/N 34-8070331 N313EMKjta LLC · Renfrew, PABuilt 1977 · S/N 28R-7703275 N314ATBerlin Airlift Historical Foundation · Farmingdale, NJBuilt 1968 · S/N 337-1047 N314DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1975 · S/N 34-7570285 N314EBRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1981 · S/N 25-0591 N314XRoss Peter W Trustee · Lufkin, TXBuilt 1975 · S/N 6134C N31530Wheeler Auctions & Real Estate LLC · Paris, MOBuilt 1978 · S/N 34-7870238 N3153KKansas Aviation Museum · Wichita, KSS/N 2 N31595Highlander Air LLC · Kalispell, MTBuilt 1978 · S/N 34-7870243 N315EBBaas Holdings LLC · Lewes, DEBuilt 1978 · S/N 34-7870357 N315PKGardisser Dennis R · Lonoke, ARBuilt 1977 · S/N R1722742 N315RHBerges Ryan R · Julesburg, COBuilt 2003 · S/N 1361 N31604Sun Mountain Flying LLC · Cody, WYBuilt 1978 · S/N 28R-7803288 N31662Star Air Service LLC · Jacksonville, FLS/N 34-7870249 N31799Kaschmitter Enterprises Inc · Grangeville, IDBuilt 1978 · S/N 34-7870266 N317PCarson Burgess Inc · Amarillo, TXS/N 1297 N31870Flight Level Aviators LLC · Glendale, AZBuilt 1978 · S/N 28R-7803302 N318RBBarker Angela · Skidmore, TXS/N 318 N318XTriple F Flying Inc · Benton, PABuilt 1975 · S/N 6145C N31906Bosveld Bobby J · Markesan, WIBuilt 1978 · S/N 28R-7837254 N31913Southern Aircraft LLC · Valdosta, GABuilt 1978 · S/N 34-7870275 N31930Patrick Juan Hughes · Hernando, FLBuilt 1978 · S/N 28R-7803305 N31994Montrose Douglas K · Glen Ellyn, ILS/N 28R-7803307 N31999Kealy Kevin · Las Vegas, NVBuilt 1978 · S/N 34-7870284 N3199VDs Victor LLC · Elburn, ILBuilt 1977 · S/N R1722242 N31GHHause James Howard · Negley, OHBuilt 1981 · S/N 25-0516 N31GSParsons John Joseph · Winter Park, FLS/N 348433021 N31VRGlaze Roy J · Smyrna, TNBuilt 1976 · S/N 33701731 N31ZWestern Skymasters LLC · Salt Lake City, UTBuilt 1973 · S/N P3370028 N32015Rock Solid Aviation LLC · Lake Charles, LABuilt 1974 · S/N 34-7570007 N3202KKennelly Kevin T · Fort Lupton, COBuilt 1946 · S/N 1195 N3216QSoma 1953 LLC · Arcadia, FLBuilt 1977 · S/N 28R-7703097 N3219KHeritage Flight Museum · Burlington, WABuilt 1968 · S/N 68-6892 N321CNInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R7803166 N321CXPollak Steven D · Cincinnati, OHBuilt 2022 · S/N 71443 N321KBBecker Kevin P · Orange, CABuilt 1977 · S/N 33701782 N321QCAden Michael L · Maryville, ILBuilt 1980 · S/N 25-0353 N321RKGaston Charles · Stephens, ARBuilt 1979 · S/N 25-0108

Back to AD 81-13-10 R1