Skip to content

Registered aircraft · 54,015

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.

N63233Gill Charles D · Baton Rouge, LABuilt 1975 · S/N 15077191 N63234Guerrero Erwin F · South Bend, INBuilt 1975 · S/N 15077192 N63237Biemer Alexander · Spring Branch, TXBuilt 1975 · S/N 15077195 N6323AGlick Brady M · Colorado Springs, COBuilt 1956 · S/N 33123 N6323BJennett Cheryl K · Phoenix, AZBuilt 1957 · S/N 34223 N6323ESwedish Flying Couching LLC · Franklin, WIBuilt 1959 · S/N 46423 N63242Douglas Dustin D · Tea, SDS/N 18052839 N63244Bacus Brent · Indianapolis, INS/N 15077199 N63246Musser John R · Freeport, ILBuilt 1975 · S/N 15077200 N63248Lewis Luther Daniel · New Bern, NCBuilt 1975 · S/N 15077202 N6324ADiaz Anthony V · Salinas, CABuilt 1956 · S/N 33124 N6324GArmstrong Paul · San Francisco, CAS/N 15071824 N6324KRegistration Pending · Princeton, NJRegistration pendingBuilt 1975 · S/N 15077643 N6324SKleis Richard L · Zwingle, IABuilt 1967 · S/N 15067124 N6324TRegistered aircraftBuilt 1984 · S/N R18201981 N63252Bork Michael F · Kalamazoo, MIBuilt 1975 · S/N 15077205 N63256Bridge To Freedom Investments LLC · Atlanta, GAS/N 15077207 N63258Cleven Randall L · Moncure, NCBuilt 1975 · S/N 15077209 N63259Lloyd Kevin S · Tacoma, WABuilt 1975 · S/N 15077210 N6325APrestegard Michael L · Delta Junction, AKBuilt 1956 · S/N 33125 N6325DCox Ronnie L · Whitesburg, GABuilt 1979 · S/N 17272717 N6325EHaider Ronald J · Southlake, TXBuilt 1980 · S/N 18504024 N6325SConfer Mark A · Fort Wayne, INBuilt 1967 · S/N 15067125 N63260Van Hise Austin S · Fort Denaud, FLBuilt 1975 · S/N 15077211 N63263Debonair Solutions LLC · Leesville, LAS/N 15077214 N63265Cessna Flyers LLC · Zephyrhills, FLS/N 15077216 N63267W A Redgate · Crescent Valley, NVS/N 18052840 N6326ANipper Melanie T · Defuniak Springs, FLBuilt 1956 · S/N 33126 N6326EKevin Formica Inc · Boca Raton, FLS/N 17272006 N6326FAirtime Holdings LLC · Charleston, SCBuilt 1979 · S/N 17273191 N6326GStephani Timothy M · White Lake, WIBuilt 1970 · S/N 15071826 N63270Louise Flyers LLC · Cheyenne, WYBuilt 1975 · S/N 15077219 N63272Glantz Charles P · Albuquerque, NMS/N 15077221 N63273Hlavinka Terrance J · East Bernard, TXBuilt 1981 · S/N 17275411 N63279P & H Air Inc · Overland Park, KSBuilt 1981 · S/N 17275412 N6327ASmith Mathias N · Weiser, IDBuilt 1956 · S/N 33127 N6327BNilsen Kim W · Hailey, IDS/N 34227 N6327ESpiro Brian F · Wonder Lake, ILBuilt 1959 · S/N 46427 N6327SHayton James B · Sedro Woolley, WABuilt 1967 · S/N 15067127 N63283Johnston Daniel · Virginia Beach, VABuilt 1975 · S/N 15077227 N63285Honan John A · Lincroft, NJBuilt 1975 · S/N 15077228 N63287Waters Brandon J · Bushnell, ILBuilt 1975 · S/N 15077230 N6328AHsd&R Enterprises Inc · Abilene, TXBuilt 1956 · S/N 33128 N6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1980 · S/N 21063865 N6328EFlies & Floats LLC · Baton Rouge, LABuilt 1980 · S/N 18504025 N6328GGoodger Jerome H · Milton, WIBuilt 1970 · S/N 15071828 N6328PSabath Kenneth J Trustee · Powell, WYBuilt 1978 · S/N P21000170 N6328YKoehn Lacey · Van Horn, TXBuilt 1981 · S/N 21064338 N63290N63290 LLC · Boulder City, NVBuilt 1975 · S/N 15077232 N63293Roesner Alvin R · Indianapolis, INBuilt 1975 · S/N 15077233

Back to AD 87-20-03 R2