Registered aircraft · 1,015

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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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.

N824AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8024 N824DHPollard Spares LLC · Roanoke, TXBuilt 1985 · S/N 3047 N825AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8025 N825SGPlane Fetch Charter LLC · Anaheim, CABuilt 1994 · S/N 5146 N826AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8026 N827AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8027 N828TKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5897 N828WGWg Aero LLC · Anchorage, AKBuilt 1991 · S/N 5080 N829AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8029 N82RLWkair 3 LLC · Boerne, TXBuilt 2001 · S/N 5485 N830AYGold Coast Aviation · Fort Lauderdale, FLBuilt 2005 · S/N 8030 N830CHWwbv Aviation LLC · Beachwood, OHBuilt 2013 · S/N 5954 N831AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8031 N831FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8061 N831PBRaynemen LLC · Pebble Beach, CABuilt 2012 · S/N 5895 N832AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8032 N832SCNwt Aircraft Co · Lexington, KYBuilt 2023 · S/N 6189 N834AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8034 N835AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8035 N836AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8036 N836CMBel Aviation LLC · Nokomis, FLBuilt 1990 · S/N 5079 N8390ADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7390 N83UFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 5083 N8409NDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7409 N840AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8040 N8416BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7416 N841FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8064 N841NPeninsula Air Logistics LLC · Palo Alto, CABuilt 2016 · S/N 6086 N841SDBluemont Leaf LLC · Houston, TXBuilt 2006 · S/N 5646 N8432ALogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7432 N843CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5660 N843GSReserve Aircrafts LLC · New York, NYBuilt 1995 · S/N 5184 N8444FLogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7444 N8458ALogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7458 N845ASDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 7324 N845SASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7965 N847CCJcpe LLC · Boston, MABuilt 2017 · S/N 6091 N8492CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7492 N8495BDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7495 N8501FDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7501 N8505QAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7505 N8506CAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7506 N850NBValiair Lc Trustee · Casper, WYBuilt 1997 · S/N 7211 N850RDLgs Holding Group 2013 LLC · Stockbridge, GABuilt 2009 · S/N 8103 N850RJUS Department Of Energy · Richland, WABuilt 1996 · S/N 7152 N8515FAm Pm Services LLC - Series One · Northbrook, ILBuilt 2001 · S/N 7515 N8516CAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7516 N851AVWells Fargo Trust Co Na Trustee · Columbia, MDS/N 7851 N851GKKkh Rentals Inc · San Antonio, TXBuilt 2006 · S/N 5643 N8525BAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7525

Back to AD 82-09-51 R1