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.

N895CCK & S Aircraft LLC · Scottsdale, AZBuilt 2007 · S/N 5727 N8960AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7960 N8964EAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7964 N8969AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7969 N8970DGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7970 N8971AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7971 N8974CSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7974 N8976ESlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7976 N8980AViajet LLC · Johnstown, PABuilt 2004 · S/N 7980 N8982AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7982 N8986BSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7986 N898AKPoppa Air II LLC · Wellesley, MABuilt 2001 · S/N 5490 N90Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N 5817 N900BHAis Aviation LLC · Newark, DEBuilt 2004 · S/N 5601 N900EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7608 N900UCBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 5519 N901EVSkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7616 N902AGT C Management Of Florida Inc · Naples, FLBuilt 2001 · S/N 5512 N902BResurrection House For All Nations Inc · Union City, GABuilt 1987 · S/N 5005 N902BWGoodfriend Aviation LLC · Knoxville, TNBuilt 2011 · S/N 5862 N902EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7620 N903AGPnc Bank Na · Boise, IDBuilt 2013 · S/N 5961 N903EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7621 N904EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7628 N905EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7632 N905SARegistered aircraftBuilt 2013 · S/N 5957 N906EVSkywest Airlines Inc · St George, UTS/N 7642 N907EVSkywest Airlines Inc · St George, UTS/N 7648 N907SALead And Steel 2 LLC · Fountain Valley, CABuilt 2004 · S/N 7934 N907WRIal Corp · Lewes, DEFirst renewal noticeBuilt 2003 · S/N 5571 N908EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7654 N908SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7540 N909EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7658 N909SWSkywest Airlines Inc · Saint George, UTBuilt 2001 · S/N 7558 N91Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N 5793 N910EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7727 N910JRegistered aircraftBuilt 2005 · S/N 5640 N910SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7566 N912EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7728 N912SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7595 N913EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7731 N914EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7752 N915EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7754 N915SWSkywest Airlines Inc · St George, UTS/N 7615 N916EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7757 N916SWSkywest Ailines Inc · St George, UTBuilt 2002 · S/N 7634 N917EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7769 N917SWSkywest Airlines Inc · Saint George, UTS/N 7641 N918SWSkywest Airlines Inc · St George, UTS/N 7645 N9191Registered aircraftBuilt 1996 · S/N 5312

Back to AD 82-09-51 R1