Skip to content

Registered aircraft · 26,232

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

N63180Hall Thomas E · Sylvia, KSBuilt 1975 · S/N 15077158 N63181Wild Blue Flight LLC · Ellensburg, WABuilt 1975 · S/N 15077159 N63186Branche Mitchell J · Winter Haven, FLBuilt 1975 · S/N 15077164 N6318EEvans Robert W · Upland, CABuilt 1959 · S/N 46418 N6318HLitz Joseph M · Indianapolis, INBuilt 1939 · S/N 19497 N63197Deangelis Kristopher M · Las Vegas, NVBuilt 1975 · S/N 15077166 N63198White Hayden · Lees Summit, MOBuilt 1975 · S/N 15077167 N63199Winfred & Waters LLC · Georgetown, TXBuilt 1975 · S/N 15077168 N6319KStemmer Kenneth Edward · Palm Desert, CABuilt 1975 · S/N 15077641 N631BTThomas Bruce A · Spring Branch, TXBuilt 1996 · S/N 2096 N631EHHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 15063361 N63205Bagwell Robert B · Sequim, WABuilt 1975 · S/N 15077173 N63207Two Star Maritime LLC · Fremont, CABuilt 1975 · S/N 15077175 N6320GBurks Michael S · Shoshone, IDBuilt 1970 · S/N 15071820 N63210Johnson Mark L · Bend, ORBuilt 1975 · S/N 15077177 N63211Prestige Worldwide Charters LLC · Edgartown, MABuilt 1975 · S/N 15077178 N63214Brady William Berte · Venice, FLS/N 15077181 N63219Cresap Dale A · Idaho Falls, IDS/N 15077185 N6321DBrown Kenneth R · Los Altos Hills, CABuilt 1946 · S/N 9117 N6321GFurlong Kelly · Athens, ALBuilt 1970 · S/N 15071821 N6321KBrookby John M · Grand Prairie, TXBuilt 1975 · S/N 15077642 N6321SStoker Dana R Trustee · Tucson, AZBuilt 1967 · S/N 15067121 N63220Ronchini Denis · Haverhill, MABuilt 1975 · S/N 15077186 N63221Ruebush Joshua K · Eaton, OHBuilt 1975 · S/N 15077187 N63231Stafford Anthony T · Collierville, TNS/N 15077189 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 N6323ESwedish Flying Couching LLC · Franklin, WIBuilt 1959 · S/N 46423 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 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 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 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 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 N6327ESpiro Brian F · Wonder Lake, ILBuilt 1959 · S/N 46427 N6327SHayton James B · Sedro Woolley, WAFirst renewal noticeBuilt 1967 · S/N 15067127 N63283Johnston Daniel · Virginia Beach, VABuilt 1975 · S/N 15077227 N63285Honan John A · Lincroft, NJBuilt 1975 · S/N 15077228

Back to AD 94-05-05 R1