Skip to content

Registered aircraft · 10,639

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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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.

N6612LSwanson Thomas J · Pukwana, SDBuilt 1974 · S/N 187409111 N6618ZRotor And Wing · Tioga, NDBuilt 1962 · S/N 25-2187 N6624ARegistered aircraftBuilt 1981 · S/N 18-8109029 N662KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 18-8209023 N6632ZFranconia Soaring Association · Franconia, NHBuilt 1963 · S/N 25-2216 N6644ZKing Jonathan R · Palmer, AKBuilt 1950 · S/N 18-362 N6647PCub Crafters Resale LLC · Yakima, WAS/N 18-347 N66512Capp Sam · Juneau, AKBuilt 1942 · S/N 51426 N66545Mcclellion William R III · Anderson, SCBuilt 1942 · S/N 5-1416 N6659ZBeltran Alejandro G · Laredo, TXS/N 25-2258 N665ABarkay Ido · Eagle River, AKBuilt 1951 · S/N 22-68 N665DWGc General Aviation LLC · Madison, NJS/N 18-7709090 N666AFFehlhaber Wolfgang M · Port Orange, FLS/N 18-8344 N666SCStephens Scott D · Vina, CAS/N 18660 N6675ZBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1963 · S/N 25-2280 N667ABlaschka Michael T · Medford, ORFirst renewal noticeBuilt 1951 · S/N 22-69 N66836Wolgemuth Jim · Anchorage, AKS/N 18-7709039 N66842Gelvin Stanley M · Central, AKBuilt 1977 · S/N 18-7709140 N6686ZKnutson Wayne R · Thompson, NDS/N 18-6686 N6687CHurtt Ben J · Mountain Grove, MOBuilt 1947 · S/N 123372 N6687ZCrop Doctor Aviation Inc · Hill City, KSFirst renewal noticeBuilt 1963 · S/N 25-2300 N66884Sea2ski Flying Club Inc · Anchorage, AKBuilt 1975 · S/N 18-7509090 N66898Registration Pending · Haines, AKRegistration pendingBuilt 1975 · S/N 18-7509091 N6689ZKingsley Kiman J · Miller, MOS/N 25-2302 N66908Herman Timothy R · Presho, SDBuilt 1975 · S/N 18-7509093 N6690DMiesko Martin A · Sprng Brk Twp, PABuilt 1954 · S/N 18-3848 N6692ZCavanaugh Flying Service Inc · Minden, NEBuilt 1963 · S/N 25-2306 N669ALeppert James J · Dickey, NDBuilt 1951 · S/N 22-71 N669AKRegistered aircraftBuilt 1954 · S/N 18-3324 N66FUGreen Steven D · Underhill, VTBuilt 1959 · S/N 22-7167 N66GJShamrock Aviation LLC · Seabrook, NHBuilt 1966 · S/N 18-8416 N66KPRegistration Pending · Batesville, TXRegistration pendingBuilt 1966 · S/N 18-8408 N66NDMiller Aircraft Services Inc · Crookston, MNBuilt 1989 · S/N 1809046 N66XYRounds Nathan A · Zebulon, GABuilt 1948 · S/N 15-189 N66YZTompkins Jeff A · Goodyear, AZBuilt 1947 · S/N 11-22 N6701BHomolka Marilyn J · Ellsworth, KSS/N 22-4037 N6701ZOsher Air LLC · Wallingford, IABuilt 1963 · S/N 25-2308 N6703ZSchneider Aerial Inc · Rugby, NDBuilt 1963 · S/N 25-2309 N6706BZvacek Dennis E Trustee · Tulsa, OKBuilt 1956 · S/N 22-4038 N6707ZHood River Soaring Inc · Hood River, ORBuilt 1963 · S/N 25-2316 N6708BHartman Darrell W · Fish Lake Valley, NVBuilt 1956 · S/N 22-4041 N6711BJohnson Nathaniel D · Attalla, ALBuilt 1956 · S/N 22-4044 N6711ZWoolslayer Joseph Patrick · Tulsa, OKBuilt 1963 · S/N 25-2320 N6714LBrost Bryan L · Canistota, SDBuilt 1974 · S/N 18-7409113 N6715ZW5 Land Services LLC · Okeechobee, FLBuilt 1963 · S/N 25-2324 N6717ZSmith Stephen A · Erwinna, PABuilt 1963 · S/N 25-2273 N6719ZJourneys Aviation Inc · Boulder, COBuilt 1963 · S/N 25-2328 N6720BGonsioroski Jerry D · Baker, MTBuilt 1956 · S/N 22-4053 N6721LDahle Air Service Inc · Anchorage, AKBuilt 1974 · S/N 18-7409114 N6724BSuchovsky Joshua A · Indianapolis, INBuilt 1956 · S/N 22-4057

Back to AD 99-01-05 R1