Skip to content

Registered aircraft · 54,019

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N2255DWeaver Walter J · Concord, NCBuilt 1952 · S/N 20407 N2255EJohnson Steven Allan · Palmer, AKBuilt 1982 · S/N 17275692 N2255XProp & Jet Air Museum Inc · Romoland, CAS/N 337-0155 N22561Buckley Holli R · Columbia, MSBuilt 1968 · S/N 15068362 N22563Davis Michael A Jr · Fairbanks, AKBuilt 1968 · S/N 15068364 N22564Darnell Stephen L · Bargersville, INBuilt 1968 · S/N 15068365 N22568Pina Gabriel B · Pasadena, CABuilt 1968 · S/N 15068368 N2256CCnd Aerospace Ltd · Telluride, COBuilt 1953 · S/N 30556 N2256DRegistered aircraftBuilt 1952 · S/N 20408 N2256SGuttzeit Aviation LLC · Baton Rouge, LAS/N R18201316 N2256XPoole Douglas G · California, MDBuilt 1965 · S/N 337-0156 N22570Nebbia Valter Della · Archer City, TXBuilt 1968 · S/N 15068369 N2257DSmith Ryan M · Greensboro, NCBuilt 1952 · S/N 20409 N2257RCanales Jorge · Anthony, NMBuilt 1978 · S/N R18200582 N22580Carter Benjamin F · Colusa, CABuilt 1976 · S/N 18503076 N22582Lee Scott M · Noble, OKBuilt 1968 · S/N 15068376 N22583Christensen Marc G · Bountiful, UTBuilt 1968 · S/N 15068377 N22584Manning Christopher S · Dawson, GABuilt 1968 · S/N 15068378 N22585Obregon Aviation LLC · San Francisco, CABuilt 1968 · S/N 15068379 N22586Weyker William J · Rhinelander, WIBuilt 1968 · S/N 15068380 N22589Robles Lazaro R · Golden Valley, MNBuilt 1968 · S/N 15068383 N2258JPluhar Darrin P · Ekalaka, MTBuilt 1979 · S/N T18803441T N2258SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 21061202 N2258TJetage Cutting Tech · Henderson, COBuilt 1968 · S/N 185-1416 N2258YConnor Thomas M · Great Falls, MTBuilt 1967 · S/N 17700058 N22590Sorensen Dale · Wellsville, UTS/N 15068384 N22594Morton Eric C · Anchorage, AKBuilt 1968 · S/N 15068388 N22595Johnson Leif M · Midlothian, TXFirst renewal noticeBuilt 1968 · S/N 15068389 N22596Anderson Bradley P · Rapid City, SDBuilt 1968 · S/N 15068390 N22597Mcmanus Charles D · Cottageville, SCBuilt 1968 · S/N 15068391 N22598Dimler Travis M · Alpine, TXBuilt 1974 · S/N 17264071 N2259MHillabrand James E · Rogers, ARBuilt 1975 · S/N 15077090 N2259RLarson Lianne N · Irvine, CABuilt 1968 · S/N T210-0409 N2259SFaireyfam Aviation LLC · Saint George, UTBuilt 1976 · S/N 21061203 N225ANCalifornia In Nice Inc · San Jose, CABuilt 1986 · S/N 17276615 N225FRDi Donato Michael · Celina, TXBuilt 1980 · S/N 17273947 N225JACoffin Paul · Sioux City, IABuilt 1979 · S/N R18201320 N225JSAircraft Holdings LLC · Edmond, OKS/N 17274385 N225KCJr Imaging Logistics Inc · Pasco, WABuilt 1969 · S/N 15070197 N225MGandiaga Philip John · Buhl, IDBuilt 1960 · S/N 52996 N225MHMissall Zoe S · Ontario, NYBuilt 1974 · S/N 17263156 N225MJOsterhout Fred · Sedro Woolley, WABuilt 1964 · S/N 17250609 N225TCameron Mark · Big Arm, MTBuilt 1969 · S/N 18259960 N225TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266946 N22602Williamson Mark T · Crescent City, CAS/N 15068396 N22609Kysar Ian R · Battle Ground, WAS/N 15068401 N2260GJump Tn LLC · Greeneville, TNBuilt 1958 · S/N 51560 N2260JSeda Oswaldo · Stockbridge, GABuilt 1966 · S/N 15065460 N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204 N2260TOrtner Airport LLC · Wakeman, OHBuilt 1977 · S/N R18200012

Back to AD 87-20-03 R2