Registered aircraft · 341

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

N1036S1036s LLC · Austin, TXBuilt 2005 · S/N 258704 N103TDTrigger Air LLC · Wilmington, DES/N 31-006 N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199 N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305 N108RLShamrock Aero LLC · Liberty, NCBuilt 2003 · S/N 258619 N109GXCfc LLC · Bloomington, INBuilt 2001 · S/N 142 N10AZAnschutz Corp · Englewood, COBuilt 1999 · S/N 178 N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190 N111KRLs 464 LLC · Colorado Springs, COBuilt 1981 · S/N 464 N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048 N115MF46 Aviation Holdings LLC · Gallatin, TNBuilt 2002 · S/N 330 N118DLN118dl LLC · Dover, DEBuilt 2003 · S/N 258607 N120JWRedge Air LLC · Jacksonville, FLBuilt 2004 · S/N 258672 N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239 N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067 N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485 N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212 N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590 N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697 N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311 N141JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 2010 N143LJBchjet3 LLC · Greer, SCS/N 143 N145LRCalchem Transportation LLC · Stockton, CABuilt 2000 · S/N 119 N146EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 146 N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324 N150SBRegistration Pending · Anchorage, AKRegistration pendingBuilt 1991 · S/N 258197 N155ERAir Medical Services LLC · Denver, NCBuilt 1984 · S/N 55-098 N156NSNunya LLC · Costa Mesa, CABuilt 2004 · S/N 258668 N158ECHhh Aviation LLC · Des Moines, IABuilt 2001 · S/N 186 N166RARoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 449 N16LJLear Holding Corp · Wilmington, DEBuilt 1986 · S/N 126 N17TVBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 258622 N183CMAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 2001 · S/N 133 N183TFRueco LLC · Lindon, UTBuilt 2005 · S/N 273 N1893NNewcomer Leasing LLC · Topeka, KSBuilt 2001 · S/N 172 N18GUKnoc LLC · Hinsdale, ILBuilt 2001 · S/N 258522 N1910AKms Air LLC · West Bend, WIBuilt 2005 · S/N 258711 N1927GDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 261 N193SGSunshine Sky Aviation LLC · Doral, FLBuilt 2003 · S/N 258627 N197ECTeam Aero LLC · Shawnee, KSS/N 197 N200FJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1980 · S/N 408 N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336 N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352 N209CQFalcon 900ex Msn 98 LLC · New Castle, DEBuilt 2001 · S/N 98 N20GPN83 Charlie Inc · Fort Wayne, INBuilt 1992 · S/N 113 N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350 N214TDHarbor Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 258332 N217MJMtk Leasing LLC · Woodburn, ORBuilt 2002 · S/N 217 N220PFExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 258542 N221CBFalcon 50ex 320 LLC · Miami Gardens, FLBuilt 2001 · S/N 320

Back to AD 2017-20-01