Skip to content

Registered aircraft · 22,413

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

N4335XPine Valley Aviation LLC · Waycross, GABuilt 1983 · S/N 28R-8431009 N43360Jamison Gustav C · Rolesville, NCBuilt 1974 · S/N 28-7415478 N43361Jordan Mark E · Fort Leonard Wood, MOBuilt 1974 · S/N 28-7405191 N4336DWing Flying Club · Lees Summit, MOBuilt 1983 · S/N 32-8406006 N4336GIn The Air Tonight LLC · Strasburg, OHS/N 32R-8413005 N4336JLaunching P.A.D. LLC · Scottsdale, AZS/N 28-22711 N4336XNew Mexico Flying Eagle Inc DBA · Tucson, AZBuilt 1975 · S/N 28-7515445 N43375Super Fly Aero LLC · Lynn, MABuilt 1974 · S/N 28-7415480 N4337FEarly Bird Aviation LLC · Phoenix, AZBuilt 1976 · S/N 28-7790016 N4337JLee Lonnie R · Wichita, KSBuilt 1967 · S/N 28-22713 N4337TBravo 3 Aviation LLC · York, NEBuilt 1971 · S/N 28R-7235011 N4337VThunderbird Aircraft Co · Bloomington, MNBuilt 1984 · S/N 28-8416045 N43380Vanderpool Aviation LLC · Liverpool, NYBuilt 1984 · S/N 28-8411009 N4338FSzmagala Taras G Jr · Bentleyville, OHBuilt 1976 · S/N 28-7790017 N4338JSky Raider Flying Club · Spokane, WABuilt 1967 · S/N 28-22714 N4338MAndrews University · Berrien Springs, MIS/N 28-8490048 N4338NMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490049 N4338PTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1984 · S/N 28-8490050 N4338TBenham Properties LLC · Sullivan, INS/N 28-7205144 N4338VFlying Mermaid LLC · Aiea, HIBuilt 1984 · S/N 28-8490052 N4339LAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1983 · S/N 32-8406007 N4339TJpm Investment Group LLC · Pascoag, RIBuilt 1971 · S/N 32-7200018 N4339WArora Three Nine Whiskey LLC · Bel Air, MDBuilt 1983 · S/N 32R-8413008 N433FLTrue North Aviation LLC · Cooperstown, NDBuilt 1971 · S/N 28-7125217 N433MASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 28-43362 N433RAHudson Allen D · Rio Grande, OHS/N 28-22705 N433STCirrus Chaser LLC · Thomasville, GABuilt 1971 · S/N 32-7100014 N43408Miloud Chadd K · Fort Worth, TXBuilt 1984 · S/N 28-8416048 N4340GHaynie Airline LLC · Boca Raton, FLBuilt 1984 · S/N 28R-8431015 N4341DFewless Aviation LLC · Coopersville, MIS/N 32R-8413009 N43422Weaver Erik J · Roseburg, ORBuilt 1974 · S/N 28-7415487 N43428Anders Judd E · Reno, NVBuilt 1984 · S/N 32R-8429007 N4342CTwin City Air Activities Inc · Rock Falls, ILBuilt 1984 · S/N 28-8416051 N4342NBeauregard Mark S · Center Valley, PABuilt 1984 · S/N 28-8411011 N4342XAlpha Aviation Inc · Mount Vernon, WAS/N 28R-7635015 N4342YSaratoga Flyers LLC · West Palm Beach, FLS/N 32R-8413010 N43431Upchurch James Stephen · Rockfield, KYBuilt 1974 · S/N 28-7425366 N43434Bg Partners LLC · El Cerrito, CABuilt 1974 · S/N 28-7415491 N4343ERegistered aircraftS/N 287405194 N4343TLeonard Alan W · Hiubee, MOBuilt 1971 · S/N 28-7225153 N43448Warrior Partners LLC · Delphi, INBuilt 1974 · S/N 28-7415495 N43449Blue Sky B&Rd LLC · Heber City, UTBuilt 1974 · S/N 28-7405195 N4344FMask Robert J Jr · Scottsdale, AZBuilt 1976 · S/N 28-7715021 N4344PAbele Benjamin · Lexington, NCBuilt 1984 · S/N 28-8490051 N4344TSpiegel Carl E · Waterford, CTBuilt 1971 · S/N 28-7205146 N43450Sidhu S Karmendra · Lattingtown, NYBuilt 1984 · S/N 32R-8413011 N43451Redwood Air LLC · Roanoke, TXBuilt 1974 · S/N 32-7440127 N43455Siskiyou Aero LLC · Ashland, ORBuilt 1984 · S/N 28-8416055 N43456Parker Air LLC · Mobile, ALBuilt 1974 · S/N 28-7415499 N4345BHamilton Justin M · Knightsen, CABuilt 1984 · S/N 28-8416057

Back to AD 87-08-08 R3