Registered aircraft · 3,126

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:2016-05-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:2016-05-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:2016-05-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:2016-05-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:2016-05-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:2016-05-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.

N40NERedding Aero Enterprises Inc · Redding, CABuilt 2000 · S/N 208B0874 N40RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BC-7 N40RDAfh Interests LLC · Fort Worth, TXBuilt 2000 · S/N LJ-1615 N40SBSan Bernadino County Sheriffs Office · San Bernardino, CABuilt 1976 · S/N BD-09 N40TTHeiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1975 · S/N 31T-7520023 N40XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N LJ-1640 N4106AAir Cover Crop Solutions LLC · Frankford, MOBuilt 2005 · S/N 802A-0223 N410GVPa1 208b-0632 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0632 N411CCSunshine Aviation LLC · Roseburg, ORS/N BB-1520 N411GCWb Air2021 LLC · Cochran, GABuilt 1997 · S/N FL163 N411GRLake Air Service LLC · Jennings, LABuilt 2002 · S/N 602-0642 N411GVPa1 208b-0672 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0672 N411JPBluffside Aero LLC · Williamsburg, VABuilt 2022 · S/N 4698229 N411RSm1019 LLC · Polson, MTBuilt 2006 · S/N 4697241 N4122XEllis Flying Service Inc · Newport, ARBuilt 2017 · S/N 802A-0692 N413AFBerry Genetics Inc · Portsmouth, NHBuilt 2024 · S/N 2413 N4149PPonderosa Airtankers LLC · Safford, AZBuilt 2007 · S/N 802A-0255 N414GJRegistered aircraftBuilt 1991 · S/N 20 N41588Echo Fox Leasing LLC · Wilmington, DES/N 6021143 N415TMCrouch Aire LLC · Westcliffe, COS/N BB-1762 N415TTT & T Capital Inc · Bangor, MEBuilt 1993 · S/N 208B0365 N41600Patriot Ag Air LLC · Huntington, INBuilt 2010 · S/N 602-1187 N41613All In Flying Co · Wilmington, DEBuilt 2008 · S/N 802A-0273 N41647Odessa Air Service Inc · Moses Lake, WABuilt 2007 · S/N 802A-0279 N41651Bank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 602-1164 N41687Over The Top Aviation Inc · Jonesboro, ARBuilt 2008 · S/N 802A-0309 N416DFUsda Forest Service · Mcclellan, CABuilt 1985 · S/N BL-124 N4170SLowry Flying Service Inc · Grinnell, IAS/N 802A-0278 N4174VDalmore Estates LLC · Los Angeles, CABuilt 2000 · S/N 4697014 N41783Fpg Agri Services LLC · Frost, TXBuilt 1987 · S/N T-34-092DC N417ARGreenway Air LLC · Orlando, FLS/N 611 N417BMMilhon Air Inc · Martinsville, INBuilt 2007 · S/N 802A-0276 N417KCFeatherstone Two LLC · Tampa, FLBuilt 2001 · S/N 417 N4185LWdw Aviation Leasing Inc · Knoxville, TNBuilt 2000 · S/N 4697025 N418JCsk Aviation Partners LLC · Fort Smith, ARBuilt 2000 · S/N BB-1705 N4191YPake Flying Service LLC · Felton, MNBuilt 2000 · S/N T660-108 N419FFMccreary Flying Service LLC · Clarksdale, MSS/N 802A-0191 N419MNSouthern Justice Aviation LLC · Houston, TXBuilt 1980 · S/N BB-785 N419TWMidwest Agri Drone LLC · Saint Joseph, MOBuilt 2014 · S/N 602-1251 N41MKEric Leasing LLC · London, KYBuilt 2023 · S/N 4698247 N42022Central Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2009 · S/N 602-1169 N4203WFast Ag Air LLC · Watertown, SDBuilt 2006 · S/N 802A-0253 N420SAKingrey William S III · Richmond, TXBuilt 1990 · S/N 402-0776 N4212JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2009 · S/N 602-1177 N4216WTri Air Farms LLC · Mamou, LAS/N 802A-0320 N4217WAviation Flying Service · Greenwood, MSS/N 602-1180 N4219MBombero Aviation LLC · Childress, TXBuilt 2007 · S/N 802A-0264 N4219WEverett Flying Service Inc · Holly Grove, ARS/N 802A-0334 N4219YTri State Aerial LLC · Canton, SDBuilt 2010 · S/N 802A-0352 N4221STri Rotor Spray & Chemical · Ulysses, KSBuilt 2008 · S/N 802A-0305

Back to AD 2016-05-13