Registered aircraft · 1,944

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.

N932BLS Lynes LLC · Wilmington, DEBuilt 2003 · S/N 1326 N932WSMarg Aviation Enterprises LLC · Lawrenceburg, TNS/N 0296 N939CGRegistration Pending · Cleveland, OHRegistration pendingBuilt 2008 · S/N 1843 N939FMBlessed Beginnings Broadcasting Inc · Warsaw, INBuilt 1997 · S/N 0321 N93DRN111vg LLC · Princeton, NJS/N 10208 N93KDTablerock Aviation LLC · Mccall, IDBuilt 2026 · S/N 14958 N93RHAttorney Holdings LLC · Dover, DEBuilt 2024 · S/N 14815 N943TTCkz Ventures LLC · Anchorage, AKBuilt 2005 · S/N 10748 N944AKSulphur Creek Helicopters LLC · George West, TXBuilt 2005 · S/N 10634 N944AREuroaviation Inc Trustee · KematenBuilt 2008 · S/N 12543 N944BALatitude 18 Helicopters LLC · Lewes, DES/N 0783 N944BGKc Aerial Storm Survey Services LLC · Kearney, MOS/N 13809 N944BHBlack Hills Helicopters Inc · Rapid City, SDBuilt 2021 · S/N 14459 N944CDFlying Easy LLC · Jacksonville, NCBuilt 2009 · S/N 1957 N944CMSale Reported · Wilmington, DESale reported, pending cancellationBuilt 2026 · S/N 14939 N944DCVt Whitlock Inc · Lake City, SCBuilt 2011 · S/N 13203 N944DKLsd 944 LLC · Norfolk, VABuilt 2009 · S/N 12639 N944GFInterstate Helicopter Inc · Bethany, OKBuilt 2014 · S/N 13708 N944GSRed River Ranch LLC · Wilmington, DEBuilt 2024 · S/N 14741 N944JMScheuermann Excavating Inc · Whitehall, PABuilt 2010 · S/N 12885 N944LC4lc LLC · Mcminnville, ORBuilt 2003 · S/N 10209 N944MRNorthwest Investments Of Oregon · Sherwood, ORBuilt 2004 · S/N 1440 N944PBAbraham Equine Inc · Canadian, TXBuilt 2019 · S/N 14323 N944PCAlba Leasing Services LLC · Phoenix, AZBuilt 2004 · S/N 10292 N944RHMountain River Aviation LLC · Mount Airy, NCS/N 14732 N944SHRegistration Pending · Texarkana, TXRegistration pending, pending cancellationBuilt 2005 · S/N 10839 N944SLLivingston Farms · Kingman, KSBuilt 2024 · S/N 14749 N944TAAlpine Air Alaska LLC · Girdwood, AKBuilt 2009 · S/N 12696 N944VBWarwick LLC · Chesapeake, VABuilt 2022 · S/N 14578 N944WTHolt Helicopters Inc · Uvalde, TXS/N 10886 N945UMd Ag Services LLC · Sterling City, TXBuilt 2005 · S/N 10763 N946BPHartland Helicopters LLC · Edinburg, TXBuilt 2000 · S/N 0909 N948WLW F Aviation LLC · Yorktown, TXBuilt 2007 · S/N 11959 N949BBDunlap Ronald W · Gold Beach, ORBuilt 2024 · S/N 14772 N94WHWest Coast Helicopters Inc · Venice, FLBuilt 2024 · S/N 14716 N952RGDragonfly Aviation LLC · Mirando City, TXBuilt 2002 · S/N 1257 N956HPN956hp LLC · Weslaco, TXBuilt 2018 · S/N 14192 N956TAAir Corriente LLC · Wilmington, DEBuilt 2014 · S/N 2380 N957CSTime Machine LLC · Plymouth, MIBuilt 2018 · S/N 14162 N95KBFront Range Heli Inc · Erie, COBuilt 2014 · S/N 2354 N95KZFly Ofa LLC · Chandler, AZBuilt 2022 · S/N 14521 N95SGJohnston Philip · Mountain Home, TXBuilt 2002 · S/N 1169 N960SRBig Rock Amusements LLC · Venice, FLBuilt 2017 · S/N 14080 N961SAEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1996 · S/N 0266 N963LWLake Superior Helicopters LLC · Duluth, MNBuilt 2001 · S/N 0963 N964CCWheeler Chris D · Boca Raton, FLS/N 12637 N964DDDavis Doyle M · Helena, MTBuilt 2022 · S/N 14510 N964DJMcculloch Randall L · Romulus, NYBuilt 1999 · S/N 0594 N96743Registered aircraftBuilt 2006 · S/N 11423 N969BTSkains Aviation LLC · Kerrville, TXBuilt 2012 · S/N 13240

Back to AD 95-26-05 R1