Registered aircraft · 463

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

N100AGDodson Intl Parts Inc · Rantoul, KSBuilt 2005 · S/N 258747 N100HLRail Transloading Services LLC · San Antonio, TXBuilt 1997 · S/N 258345 N1036S1036s LLC · Austin, TXBuilt 2005 · S/N 258704 N104EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2000 · S/N 258505 N104LRTri Aviation Inc · Venetia, PABuilt 1996 · S/N 258303 N107LTHabari Inc · Rancho Cucamonga, CABuilt 2008 · S/N 258901 N108RLShamrock Aero LLC · Liberty, NCBuilt 2003 · S/N 258619 N109RCapital Air Sc LLC · Wilmington, DEBuilt 2008 · S/N HA-0076 N110GDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258713 N110WSPack Wikert II LLC · Anchorage, AKBuilt 1998 · S/N 258388 N111MDArgosy Aircraft Inc · Reno, NVBuilt 2007 · S/N HA-0035 N117WHNobelstar Holdings LLC · Flower Mound, TXBuilt 2009 · S/N HA-0140 N118DLN118dl LLC · Dover, DEBuilt 2003 · S/N 258607 N118UFUnited Fire & Casualty Co · Cedar Rapids, IABuilt 2011 · S/N HA-0183 N120JWRedge Air LLC · Jacksonville, FLBuilt 2004 · S/N 258672 N123EDFrench Fly LLC · San Jose, CAS/N 258366 N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485 N130GSVisionary B LLC · Chattanooga, TNBuilt 2008 · S/N 258961 N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590 N1318AAnsaki Aviation LLC · Bloomfield Hills, MIBuilt 2008 · S/N HA-0078 N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697 N141ALAllete Enterprises Inc · Duluth, MNBuilt 2008 · S/N HA0055 N146JFJ F Air Traffic Inc · Temple, TXBuilt 2010 · S/N HA-0160 N14PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 258317 N150JMPog Capital LLC · Wilmington, DEBuilt 1998 · S/N 258382 N154RRN154rr LLC · Wilmington, DEBuilt 1998 · S/N 258375 N156NSNunya LLC · Costa Mesa, CABuilt 2004 · S/N 258668 N159FMC&K Air LLC · New Castle, DEBuilt 2003 · S/N 258651 N15RKPlane Part Solutions LLC · Lake Park, FLBuilt 1996 · S/N 258297 N163DKHorizontal Ventures LLC · Lowell, INBuilt 2008 · S/N HA-0042 N167SCSage Creek Aviation LLC · American Canyon, CABuilt 2005 · S/N 258742 N167XPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N HA-0167 N16SMJokity Holdings LLC · Richmond, VABuilt 2007 · S/N HA-0040 N176USJd76 Air LLC · Chesterfield, MOBuilt 2007 · S/N HA-0029 N1776CDvyxv Fund III LLC · Waxhaw, NCBuilt 2007 · S/N HA-0002 N17ENKare Air LLC · Paradise Valley, AZBuilt 2009 · S/N HA-0102 N17RMWard Acres Farms Texas LLC · Austin, TXBuilt 2008 · S/N HA-0069 N17TVBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 258622 N183DMDodson International Parts Inc · Rantoul, KSS/N 258335 N188BPatriot Air LLC · Allentown, PAS/N 258822 N18AAAtlantic Prime Corp · Miami, FLBuilt 2008 · S/N HA-0068 N18GUKnoc LLC · Hinsdale, ILBuilt 2001 · S/N 258522 N190SWRouse Holdings LLC · Schriever, LABuilt 2008 · S/N HA-0079 N1910AKms Air LLC · West Bend, WIBuilt 2005 · S/N 258711 N1910HHallmark Cards Inc · Kansas City, MOBuilt 2011 · S/N HA-0190 N192SAAdams Aviation LLC · Charlotte, NCBuilt 2011 · S/N HA-0192 N193SGSunshine Sky Aviation LLC · Doral, FLBuilt 2003 · S/N 258627 N1953KKms Air LLC · West Bend, WIBuilt 2006 · S/N 258775 N1980RRae Mae Air LLC · Coraopolis, PABuilt 2008 · S/N HA-0070 N19KBKontoor Services LLC · Greensboro, NCBuilt 2008 · S/N HA0059

Back to AD 2014-15-08