Skip to content

Registered aircraft · 22,416

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.

N75134N75134 LLC · Honolulu, HIS/N 28-7615256 N75136Montgomery Carson B · Divide, COBuilt 1976 · S/N 28-7690300 N75138High Island Seamless Inc · Gaylord, MNS/N 28-7690302 N7513JHenslin Maja Blu · Wyoming, MNBuilt 1968 · S/N 28R-30880 N7513RAnderson Agency Inc · Racine, OHBuilt 1966 · S/N 28-22070 N75141Three Guys Who Fly LLC · Flint, MIBuilt 1976 · S/N 32-7600015 N75143Raisch Horst F · Aptos, CABuilt 1976 · S/N 32R-7680263 N75146Gaiser Richard Mark · Berrien Springs, MIBuilt 1976 · S/N 28-7625203 N75147Hermes John P · Tarpon Springs, FLBuilt 1976 · S/N 28-7615258 N75149Ryan Samuel P · Kodiak, AKS/N 28-7615260 N7514RN7514r LLC · Las Vegas, NVBuilt 1966 · S/N 28-22071 N75151Olsen Aviation LLC · Atlantic, IABuilt 1976 · S/N 28-7690304 N75152Gibb John R · Ellensburg, WABuilt 1976 · S/N 28R-7635270 N75153Island Aviation Management LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635271 N75158Bowman Aviation LLC · Sebewaing, MIS/N 28-7625204 N7515JCrock Brent S · Enterprise, ALBuilt 1968 · S/N 28R-30882 N7515RRoquet Steven L · Fremont, IABuilt 1966 · S/N 28-22072 N7515WAir Services Inc · Roca, NEBuilt 1963 · S/N 28-1431 N75162Mccann Michael H · Santa Ynez, CABuilt 1976 · S/N 28-7615261 N75163Bryant Donald Kelly · Sullivan, MOBuilt 1976 · S/N 28-7615262 N75164Sinkovich Pete · Phoenix, AZBuilt 1976 · S/N 28-7615263 N75165Maple Shores LLC · Helena, MTBuilt 1976 · S/N 28-7690305 N75169Flight School Inc · Spring, TXBuilt 1976 · S/N 28-7690306 N7516JBeard Don Ricarde · Rockledge, FLS/N 28R-30883 N7516WGreen Andrew · Hillsboro, TXBuilt 1963 · S/N 28-1432 N75171Horsepower Aviation LLC · Gilroy, CABuilt 1976 · S/N 28-7610110 N7517410 Skies LLC · Rockport, TXBuilt 1976 · S/N 28-7625205 N75177Labrash Barbara J · Eastsound, WAS/N 28-7615265 N75179K4-S Flight Training LLC · Santa Rosa, CABuilt 1976 · S/N 28-7690308 N7517JWright Aviation LLC · San Francisco, CABuilt 1968 · S/N 28R-30884 N7517RGarringer William E · Pryor, OKBuilt 1966 · S/N 28-22074 N75182Donkel Douglas L · Hillsboro, ORBuilt 1976 · S/N 28R-7635282 N75186Lessenberry James F · Leonard, MIBuilt 1976 · S/N 28-7625206 N75187N75187 LLC · Fulton, MOBuilt 1976 · S/N 28-7615266 N7518JEsposito Michael I · Raleigh, NCBuilt 1968 · S/N 28R-30886 N7518WNywhb Properties · Westhampton Beach, NYBuilt 1965 · S/N 28-2910 N75190FAA Flying Club Inc · Atlantic City, NJBuilt 1976 · S/N 28-7690309 N75193Groton Flyers LLC · Bozrah, CTBuilt 1976 · S/N 28-7690311 N75195Swaz Aviation LLC · Mesa, AZS/N 32R-7680277 N75196Woodberry Robert A · Mineral, VABuilt 1976 · S/N 32R-7680278 N75198Flightline LLC · Kaysville, UTBuilt 1976 · S/N 28-7615300 N751BSVenture North Aviation LLC · Cloquet, MNBuilt 2025 · S/N 2881878 N751KSWarstler Michael · Dayton, OHBuilt 2014 · S/N 2844153 N751LBN6105s LLC · Norwood, NCBuilt 2005 · S/N 3246228 N751PCVenture North Aviation LLC · Cloquet, MNBuilt 2023 · S/N 28020103 N751RJFeakins Oliver · Lititz, PABuilt 1980 · S/N 28-8011108 N751WTVenture North Aviation LLC · Cloquet, MNBuilt 2022 · S/N 2881584 N751YZVenture North Aviation LLC · Cloquet, MNBuilt 2023 · S/N 2881630 N75200Rockwell Aviation LLC · Aventura, FLBuilt 1976 · S/N 28-7615268 N75202Plane Nonsense Inc · Middletown, DEBuilt 1976 · S/N 28-7615269

Back to AD 87-08-08 R3