Registered aircraft · 816

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

N7148AHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 3716 N7154WBeller Construction & General Contracting LLC · Lewiston, IDBuilt 2004 · S/N 3720 N7155WHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1997 · S/N 2759 N7158DTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2004 · S/N 3721 N7158SHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2004 · S/N 3689 N7168HHindes Philip W DBA · Charlotte, TXBuilt 1999 · S/N 2941 N7168UMorris Charles P · Uvalde, TXBuilt 1999 · S/N 2911M N7183XMoor Halley R Jr · Hankamer, TXS/N 2887 N7186JBenavides Roberto O Jr DBA · Falfurrias, TXBuilt 2001 · S/N 3221 N7186RRays Aircraft Sales LLC · Tolland, CTBuilt 2000 · S/N 3061 N7187KCullman Rotorcraft Inc · Vinemont, ALBuilt 2000 · S/N 3099 N7187SDakma LLC · Parma, OHBuilt 1999 · S/N 2969 N7187WNew York Art Upholstery LLC · New York, NYBuilt 1989 · S/N 0955M N7188JMansfield Heliflight Inc · Milton, VTBuilt 2000 · S/N 3094 N7188NTurn And Climb Aviation Co · Wilmington, DEBuilt 2000 · S/N 3098 N7189KEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2000 · S/N 3118 N7190CJets To Helis LLC DBA · Chandler, AZBuilt 2002 · S/N 3364 N7190JEmerald City Aircraft Leasing Inc · Port Orchard, WAS/N 3109 N7191EStandard Aviation Services LLC · Farfurrias, TXBuilt 2000 · S/N 3120 N71921Rychlik Kevin Charles · Manassas, VAS/N 3437 N7192SUniversal Technical Institute Inc · Phoenix, AZBuilt 2000 · S/N 3058 N7193UJets To Helis LLC DBA · Chandler, AZBuilt 2001 · S/N 3161 N7194KHolt Tommy · Big Lake, TXBuilt 2000 · S/N 3146 N7195EMn Helicopters Inc · Blaine, MNBuilt 2000 · S/N 3158 N7195ZDenis Ranch · Vancourt, TXBuilt 2001 · S/N 3246 N7196WJets To Helis LLC DBA · Chandler, AZBuilt 2000 · S/N 3140 N7197ZAero Tech Academy Inc · Redlands, CANon-citizen corporation, flight hours not reportedBuilt 2001 · S/N 3249 N7198AFlying J Services LLC · Jourdanton, TXBuilt 2001 · S/N 3216 N7198JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3232 N7198NAero Leasing Inc · Medford, ORBuilt 2001 · S/N 3168 N71FHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1724M N71GARosso Corsa Motors Inc · Colorado Springs, COBuilt 2004 · S/N 3727 N721GHGuidance Helicopters Inc · Prescott, AZBuilt 2005 · S/N 3986 N721HHHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1990 · S/N 1484 N721RJGenes Helicopter Leasing LLC · Durham, MEBuilt 1998 · S/N 2860 N7228DAmigo Helicopter Services LLC · Falfurrias, TXS/N 3725 N722HAPerformance Sanitation Of Mississip · Deland, FLBuilt 1998 · S/N 2863 N722MCClassic Banjo LLC · Richmond, KYS/N 2374 N722PGFuller Jon A · Goliad, TXBuilt 2005 · S/N 3773 N722RHTb Aero Inc · Wilmington, DES/N 4122 N722RKKipp Russell E · Fernandina Beach, FLS/N 0962 N723MLVertical Corp · Kalispell, MTBuilt 1996 · S/N 2639 N724JHJets To Helis LLC DBA · Chandler, AZBuilt 2018 · S/N 4777 N726KDRobinson Helicopter Co · Torrance, CAS/N 4961 N727DDAlba Aviation Services Inc · Scottsdale, AZBuilt 2002 · S/N 3328 N728TKStefanidis Dimitri T · Lake Oswego, ORBuilt 2026 · S/N 4936 N72GAGuidance Helicopters Inc · Prescott, AZBuilt 2006 · S/N 4048 N72GRWell Point Inc · La Verne, CAS/N 4588 N7373GJones Stonie C · Crescent City, FLS/N 3739 N7379HHiggins Leasing Inc · The Woodlands, TXBuilt 2026 · S/N 4935

Back to AD 88-26-01 R2