Skip to content

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.

N947SASlate Aircraft Company LLC · Johnstown, PAS/N 7963 N947SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7786 N949MCWolfpack Aviation LLC · Tysons, VABuilt 2010 · S/N 5829 N949SJSierra Delta Romeo LLC · Scottsdale, AZBuilt 1996 · S/N 7136 N94SFTriad Aviation LLC · Tyler, TXBuilt 2007 · S/N 5708 N95Federal Aviation Administration · Oklahoma City, OKBuilt 2010 · S/N 5827 N951RMSiilats Keith · New York, NYS/N 3042 N951SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7795 N952SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7805 N953SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7813 N954BASentinel Services Group LLC · Brooksville, FLS/N 5054 N954SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7815 N955SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7817 N955TMCharon Services LLC · Sheridan, WYBuilt 2009 · S/N 5759 N956SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7825 N957SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7829 N958SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7833 N959SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7840 N960SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7853 N961SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7857 N961TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5928 N962SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7859 N963SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7865 N964SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7868 N965SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7871 N967BGE&B Ride LLC · Greenwich, CTBuilt 2009 · S/N 5800 N967SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7872 N969PWCh604 LLC · Southfield, MIBuilt 2005 · S/N 5604 N969SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7876 N96EAAuburn-Lewiston Municipal Airport · Auburn, MEBuilt 2002 · S/N 7700 N970SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7881 N971SWSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 7947 N972MCMiddlesex Aviation LLC · Littleton, MABuilt 2012 · S/N 5908 N973SWSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 7949 N974BHFintail 605 LLC · New York, NYBuilt 2008 · S/N 5736 N975SWSky West Airlines Inc · Saint George, UTBuilt 2004 · S/N 7951 N976SWSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 7952 N9771CBimo 3.0 LLC · Spring Hill, FLS/N 5063 N978ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 5502 N978SWSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 7953 N979EVLogos Aviation Inc · Fort Lauderdale, FLBuilt 2003 · S/N 7737 N979SWSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 7954 N97EADodson International Parts Inc · Rantoul, KSBuilt 1993 · S/N 7027 N980EVGold Coast Aviation · Fort Lauderdale, FLBuilt 2003 · S/N 7759 N980RRWkair 2 LLC · Boeme, TXBuilt 2001 · S/N 5503 N980SWSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 7955 N981EVSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2003 · S/N 7768 N982SWSky West Airlines Inc · Saint George, UTBuilt 2004 · S/N 7956 N983CRTrial By Human Air LLC · Decorah, IABuilt 2010 · S/N 5841 N983SWSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 7961

Back to AD 82-09-51 R1