Registered aircraft · 967

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

N427GYG S D Rentals Inc · Norco, CABuilt 2015 · S/N 680-0542 N427RCIndel Services LLC · Rancocas, NJBuilt 2012 · S/N 510-0423 N428SSCurly Flyer LLC · Libertyville, ILBuilt 2005 · S/N 680-0041 N42WZAdvanced Plastic Extrusion LLC · Pollocksville, NCBuilt 2009 · S/N 510-0175 N431CXair LLC · Cloudcroft, NMBuilt 2009 · S/N 510-0208 N440MCMclane Company Inc · Temple, TXBuilt 2024 · S/N 680A0388 N442LVWachob Leasing Co Inc · Sapulpa, OKBuilt 2009 · S/N 510-0153 N444AWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 680A0003 N444DNDan Newlin Jet Aviation LLC · Orlando, FLBuilt 2017 · S/N 680A0085 N445SCAuro Logistics Two LLC · Greenville, SCBuilt 2018 · S/N 680A0143 N447ECAngus Energy LLC · Dallas, TXBuilt 2006 · S/N 680-0098 N448KCKinsley Construction LLC · York, PABuilt 2019 · S/N 680-0588 N448SJClydesdale Asset Management LLC · Park City, UTBuilt 2014 · S/N 510-0448 N44BRTextron Aviation Inc · Wichita, KSS/N 680A0497 N44DTAirtrade Aviation Corp · Fort Lauderdale, FLBuilt 2011 · S/N 510-0368 N44SH44sh LLC · Oklahoma City, OKBuilt 2005 · S/N 680-0023 N455SCCanvasback LLC · Maumee, OHBuilt 2024 · S/N 680A0392 N458MCMclane Company Inc · Temple, TXBuilt 2019 · S/N 680A0187 N45AYTvpx Aircraft Solutios Inc · North Salt Lake, UTBuilt 2016 · S/N 680-0559 N45JKAuto Force One LLC · Memphis, TNBuilt 2008 · S/N 680-0224 N45NFNoble Research Institute LLC · Ardmore, OKBuilt 2016 · S/N 680-0556 N45VPUnmanned Systems - 45vp LLC · Kalispell, MTBuilt 2012 · S/N 510-0417 N461TAEastern Aviation Fuels Inc · New Bern, NCBuilt 2014 · S/N 680-0519 N463TMNapeequa Holdings LLC · Miami, FLBuilt 2009 · S/N 510-0169 N464TRegistered aircraftBuilt 2016 · S/N 680A0064 N4674Sanibel Aviation LLC · Brownsburg, INBuilt 2015 · S/N 680A0011 N467VCouch Aviation Holdings LLC · Lexington, KYBuilt 2007 · S/N 680-0132 N46BWAir Weaver LLC · Mars, PABuilt 2007 · S/N 510-0012 N470SKSnk Real Property Holdings LLC · Meta, MOBuilt 2024 · S/N 680A0396 N471CB888tn LLC · Collinsville, OKBuilt 2017 · S/N 680-0576 N472CBInner Harbor 100 LLC · Baltimore, MDBuilt 2019 · S/N 680A0219 N475CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 680A0475 N477BBJeta Mae LLC · Naples, FLBuilt 2007 · S/N 680-0138 N479DCAlijim Ltd LLC · Lewes, DEBuilt 2010 · S/N 510-0302 N47SBWabash Aviation LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 2017 · S/N 680A0096 N47SCFt Leasing Inc · Memphis, TNBuilt 2017 · S/N 680A0119 N483TWLandmark Sovereign Holdings LLC · Houston, TXBuilt 2007 · S/N 680-0143 N484CWRandolph Aviation LLC · Bridgeport, WVBuilt 2008 · S/N 510-0131 N484HBLee Air LLC · Park Hills, MOBuilt 2012 · S/N 510-0426 N484TYRangeflyers Inc Trustee · Wichita, KSBuilt 2026 · S/N 680A0484 N484VBWestern States Aviation LLC · Laguna Beach, CABuilt 2010 · S/N 510-0329 N48XLSeven Wolves LLC · Pinebluff, NCBuilt 2024 · S/N 680A0389 N495JKMax Aero LLC · Dayton, OHBuilt 2010 · S/N 510-0296 N497NMRegistration Pending · Mcdonough, GARegistration pendingBuilt 2014 · S/N 6800507 N499MDMarvin Leasing LLC · New Hope, MNBuilt 2017 · S/N 680A0100 N4FFCny Flying Cardiac Services LLC · Fayetteville, NYBuilt 2007 · S/N 510-0007 N4PGFourpapagolf LLC · Saint Petersburg, FLBuilt 2008 · S/N 510-0136 N4ZCZachry Industrial Inc · San Antonio, TXBuilt 2006 · S/N 680-0077 N501QSRegistered aircraftBuilt 2016 · S/N 680A0037 N501SSignature Aviation LLC · Sioux Falls, SDBuilt 2011 · S/N 510-0382

Back to AD 2018-07-13