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.

N373HDHinkle Air Spray Inc · Cavalier, NDBuilt 2001 · S/N 502B-0636 N375BCYellowstone Leasing LLC · Pray, MTBuilt 1991 · S/N FL-56 N375RDDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 4697003 N377LAFickes Aerial & Ag Services LLC · Norfolk, NEBuilt 1996 · S/N 502B-0377 N378AWSkyline Aviation Services LLC · Miramar, FLS/N UE-378 N378HHGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N 378 N37HDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-48 N37TDTwin Disc Inc · Racine, WIBuilt 1990 · S/N FL-25 N381MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3703 N382MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3704 N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747 N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615 N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383 N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158 N385LABrunetti Finley Jr · Shelby, MSBuilt 2010 · S/N 802A-0385 N385MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3707 N386AFBank Of Utah Trustee · Portsmouth, NHBuilt 2024 · S/N 2386 N386ARRustic Corp · Fort Worth, TXBuilt 1999 · S/N 208B0787 N386ATAirtrex Aircraft Mike Inc · Wichita, KSS/N FL-416 N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775 N386LAHinkle Airspray Inc · Cavalier, NDBuilt 2010 · S/N 802A-0386 N387ATAirtrex Aircraft November Inc · Wichita, KSS/N FL-449 N387SCHeritage Aviation Management Ltd · Conroe, TXBuilt 1999 · S/N FM-10 N388TWTl Lobo Group LLC · Rockwall, TXBuilt 2000 · S/N 4697018 N389DDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N FL389 N389LABailey Air LLC · Delhi, LABuilt 2010 · S/N 802A-0389 N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439 N38VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-105 N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313 N390PSMcm Holdings Inc · Lincoln, NES/N LW-279 N391ACAmerican Champion Aircraft Corp · Rochester, WIBuilt 1979 · S/N 400-98 N391HCFly-Area LLC · Charleston, SCBuilt 1988 · S/N FA165 N392FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 602-1392 N392KWSpradin Flying Service Inc · Petersburg, TXBuilt 2007 · S/N 802A-0282 N392LAC&L Holzwarth Inc · Virden, ILBuilt 2025 · S/N 602-1391 N392TMCentral Farmer'S Cooperative DBA · Ville Platte, LABuilt 2009 · S/N 602-1179 N393LAC&L Holzwarth Inc · Virden, ILBuilt 2024 · S/N 802A-1093 N394ALTeebird Enterprises LLC · Brighton, COFirst renewal noticeBuilt 1968 · S/N LJ394 N394LAAerial Solutions Of Tennessee LLC · Milan, TNBuilt 1994 · S/N 502B-0242 N394SFCity Wings Inc · St Thomas, VIBuilt 2005 · S/N 20800394 N394TMWebb Flying Service Inc · Coy, ARBuilt 2016 · S/N 602-1279 N395AAAdvanced Air LLC · Hawthorne, CABuilt 1991 · S/N FL39 N395ABFr Air LLC · Palm Harbor, FLBuilt 1999 · S/N LJ-1575 N395MBAdvanced Air LLC · Hawthorne, CABuilt 2002 · S/N FL-347 N396FWRoute 66 Aerostars LLC · Galena, KSBuilt 1980 · S/N 428001021 N396LANeal Aircraft Inc · Slaton, TXS/N 802A-0331 N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421 N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012 N397LAWil-Co Flying Service LLC · Dewitt, ARBuilt 2009 · S/N 802A-0332 N398LAWestern Pilot Service Inc · League City, TXBuilt 2007 · S/N 802A-0263

Back to AD 2016-05-13