Registered aircraft · 1,939

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

N17ZEAlpha Aviation LLC · Anchorage, AKBuilt 2024 · S/N 14757 N181AFSmoketown Helicopters LLC · Smoketown, PABuilt 2010 · S/N 2100 N181MBSpitzer Helicopter LLC · Woodland Hills, CABuilt 2016 · S/N 2425 N183ASCorporate Helicopter Leasing · Dallas, TXBuilt 2000 · S/N 0827 N183PSHc02 LLC · Vero Beach, FLBuilt 2014 · S/N 2328 N183TYEuroaviation Inc Trustee · KematenBuilt 2019 · S/N 14319 N1862ZHelmbrecht Michael J · Fairbanks, AKBuilt 2016 · S/N 13965 N186TCNauti By Nature LLC · Colorado Springs, COBuilt 2004 · S/N 10274 N187JHSouthern Ag Helicopter Services LLC · Zebulon, NCBuilt 1995 · S/N 0203 N189LAHd & H Aviation LLC · Veedersburg, INBuilt 2011 · S/N 13131 N189MXL&W Holdings LLC · North Fort Myers, FLBuilt 2012 · S/N 2194 N189TWHolt Helicopters Inc · Uvalde, TXBuilt 2005 · S/N 11025 N18EKKrahenbuhl Edward L Trustee · Waldport, ORBuilt 2018 · S/N 30042 N18FHParatus Air Inc · Auburn, INBuilt 1999 · S/N 0651 N18MQCr Helicopters Inc · Nashua, NHBuilt 2000 · S/N 0830 N18NE330am Holding Corp · Miami, FLBuilt 2020 · S/N 14386 N18RHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2020 · S/N 14404 N18YLTj Helicopters LLC · Seymour, TNBuilt 2006 · S/N 11171 N194SNautidogs Aero LLC · Kalispell, MTBuilt 2018 · S/N 14279 N1953RSmith Helicopters Inc · Cotulla, TXS/N 30018 N1958CCsd Enterprises Inc · Wilmington, DEExpired dealer, pending cancellationBuilt 2013 · S/N 13600 N195SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 11755 N196DMBenitez Aviation Inc · San Juan, PRBuilt 2006 · S/N 11329 N1971GW & J Aviation LLC · Missoula, MTS/N 13606 N1976BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 0637 N197BJChavi LLC · Fredericksburg, TXBuilt 2013 · S/N 13471 N197HLCedar Ridge Aviation LLC · Knox City, TXBuilt 2004 · S/N 1386 N197JPAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2006 · S/N 11395 N197SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 14091 N199CDAris Aviation Group LLC · Henderson, NVS/N 13639 N19TFSummerhill Property LLC · Piedmont, SCBuilt 2023 · S/N 14620 N2007CAviation Innovations LLC · Dover, DEBuilt 2004 · S/N 10533 N202BRRc Aviation LLC · Ladysmith, WIBuilt 2020 · S/N 2616 N202GHChesapeake Bay Helicopters Inc · Chesapeake, VABuilt 2018 · S/N 14202 N202WTEngstad Kai · Gig Harbor, WABuilt 2008 · S/N 1847 N203LELeading Edge Flight Academy LLC · Bend, ORS/N 11203 N204DJl Leasing LLC · Elbow Lake, MNBuilt 2004 · S/N 1447 N204LCUtah State University · Logan, UTBuilt 2004 · S/N 10248 N204MCB-Line Air LLC · Malcom, IABuilt 2008 · S/N 12596 N204TVScott C Fuller Development LLC · Moultonborough, NHBuilt 2005 · S/N 10723 N205RBCm3 LLC · North Las Vegas, NVS/N 11805 N205SHBuzzard Aviation Inc · Freer, TXS/N 0773 N206TJSky Solutions LLC · Detroit, MIBuilt 2006 · S/N 11097 N207PDFirefly Leasing Inc · South Carver, MABuilt 2003 · S/N 1330 N208GD101gd Corp · Miami, FLBuilt 2026 · S/N 14926 N208KSRegistered aircraftBuilt 2008 · S/N 12231 N209AGSkyfarm Leasing LLC · Dos Palos, CABuilt 2023 · S/N 14624 N20DDBeaver Robbie L · Eldorado, ILBuilt 2013 · S/N 13539 N20FHSky Solutions LLC · Detroit, MIBuilt 2008 · S/N 12348 N20LAPet Care Centers Of America LLC · Helena, MTS/N 11699

Back to AD 95-26-05 R1