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.

N143VAKaman Arms LLC · Paron, ARBuilt 2009 · S/N 12747 N1440LInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 11731 N144AFHelius Aircraft 144af LLC · Conroe, TXBuilt 2007 · S/N 1787 N144AHAtomic Helicopters LLC · Seattle, WABuilt 2001 · S/N 0865 N144AKExpress Helicopters LLC · Houston, TXBuilt 2004 · S/N 10226 N144AXAngelone Inc · Elkhart, INBuilt 2007 · S/N 11827 N144BVSouthern Utah University · Cedar City, UTBuilt 2014 · S/N 13737 N144BWSkyward Leasing LLC · Kalispell, MTBuilt 2007 · S/N 12076 N144BZCrosswind Leasing LLC · Prescott, AZBuilt 2005 · S/N 10715 N144CDLittle Gator Aviation Inc · Fairfield, NCBuilt 1999 · S/N 0602 N144CLStewart Joseph W II · Eloy, AZBuilt 2006 · S/N 10980 N144DJSaybrook Offshore LLC · Guilford, CTBuilt 2017 · S/N 2467 N144DMExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2003 · S/N 10044 N144DSStevenson William E · Sutton, AKBuilt 2000 · S/N 0715 N144DZAurora Helicopters LLC · Lansing, ILBuilt 2003 · S/N 10100 N144EHScout Aviation LLC · Odessa, TXBuilt 2005 · S/N 10742 N144ESSpain Heliventures LLC · Wilmington, DEBuilt 2003 · S/N 10228 N144FLSouth Florida Helicopters Inc · Indiantown, FLS/N 0654 N144GDRandall B Langley Licensed Real Estate Broker LLC · Longboat Key, FLS/N 12706 N144GGAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2018 · S/N 14212 N144GHTrack Up Trading Corp · Cheyenne, WYBuilt 2007 · S/N 12077 N144JDDeviation LLC · Raleigh, NCBuilt 2000 · S/N 0938 N144JGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2000 · S/N 0859 N144JJQcp Group LLC · Lafayette, LABuilt 1999 · S/N 0689 N144KWAloha Helicopter Tours LLC · Lihue, HIBuilt 2009 · S/N 12805 N144LRTj Holdings Inc Trustee · Wilmington, DEBuilt 2008 · S/N 12242 N144MNHaynes Michael W · Odessa, TXBuilt 2006 · S/N 1555 N144PCDown To Fly 2 Day LLC · Dover, DEBuilt 2006 · S/N 11082 N144PDCalifornia Aviation Services Inc · Riverside, CABuilt 2003 · S/N 10033 N144PGCsi Flight Services LLC · Mcminnville, ORBuilt 2008 · S/N 12349 N144PPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 12689 N144RFRio Farms LLC · King City, CABuilt 2002 · S/N 1223 N144RHRiada Inc · Newport Beach, CABuilt 2007 · S/N 11585 N144RPBenrud Aviation LLC · Rice, MNS/N 0766 N144SGHolt Helicopters Inc · Uvalde, TXS/N 11880 N144SRCedar Ridge Aviation LLC · Knox City, TXBuilt 2003 · S/N 10079 N144VGVista Grande Helicopters Inc · Merritt Island, FLS/N 1101 N144WARotor Leasing LLC · Indianapolis, INBuilt 2018 · S/N 14216 N144WBUniversal Aviators Academy Inc · El Monte, CABuilt 1998 · S/N 0545 N144WKWestern Kentucky Leasing LLC · Philpot, KYBuilt 2005 · S/N 10639 N144WTPerformancez LLC · Nederland, TXS/N 0601 N145PDSpitzer Helicopter LLC · Wilmington, DEBuilt 2006 · S/N 11179 N145TRRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 15020 N145VAVeracity Aviation LLC · Seguin, TXS/N 13482 N146SGVertical Flight LLC · Safety Harbor, FLBuilt 2005 · S/N 1496 N147TCSundance Aero LLC · Mertzon, TXBuilt 2006 · S/N 11103 N148RHPlum Aggregate LLC · Porter, TXBuilt 2017 · S/N 14048 N149PKLange Helicopters Inc · San Angelo, TXBuilt 2006 · S/N 11570 N14MYSouth Florida Helicopters Inc · Indiantown, FLS/N 1149 N14QAAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 11370

Back to AD 95-26-05 R1