Skip to content

Registered aircraft · 6,349

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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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.

N46762Kay Bennie L · Brigham City, UTBuilt 1978 · S/N 15283102 N4676ZNielsen Nancy A · Eugene, ORBuilt 1961 · S/N 22-8209 N4678ZQrh LLC · Bartlesville, OKBuilt 1961 · S/N 22-8213 N46803Ken Graham Phd Inc · Sioux Falls, SDBuilt 1979 · S/N 15283108 N4680ZPropelling The Gospel Missions Inc · Standish, MEBuilt 1961 · S/N 22-8215 N46826Registration Pending · Tampa, FLRegistration pendingBuilt 1979 · S/N 15283114 N4684ZGordon Stephen M · Velpen, INBuilt 1961 · S/N 22-8219 N46854Phillips Joe Christopher · Grand Prairie, TXBuilt 1979 · S/N 15283121 N4685SSeneca Aeronautical Services LLC · Wilmington, DEBuilt 1965 · S/N EC-1 N4686ESieh Colton David · Kotzebue, AKS/N 7EC-34 N4686LGlenn Roger H · Pacifica, CABuilt 1980 · S/N 15284216 N4686ZMacmoyle Scott · Blairstown, NJBuilt 1961 · S/N 22-8222 N4687MHock Rocky · Culbertson, NEBuilt 1947 · S/N 11-196 N46889Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283133 N4688ZBurlew Richard · Richlands, NCBuilt 1961 · S/N 22-8225 N4689ZDavis James J · Leonardtown, MDBuilt 1961 · S/N 22-8227 N46907Bagamaspad Alan Antonio · Los Angeles, CABuilt 1979 · S/N 15283137 N4690ZFialcowitz Thomas L · Hotchkiss, COBuilt 1961 · S/N 22-8228 N46953Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 15283149 N46964Simsbury Aviation Services LLC · Simsbury, CTBuilt 1979 · S/N 15283152 N4697ZAntesberger Edward A · Fairfax, VABuilt 1961 · S/N 22-8237 N469RAChorice Kenneth · Bartlett, TNBuilt 1978 · S/N 38-78A0531 N46AARutan Aircraft Flying Experience · Waller, TXBuilt 1981 · S/N 46 N46FPGarner Jerry L · Sugar City, IDS/N 12-249 N47028My Way Aviation LLC · Weston, FLS/N 15283159 N47029Geronimo Aviation LLC · Scottsdale, AZBuilt 1979 · S/N 15283160 N4702PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284801 N4703ZStarling Ronald A · Prescott, AZBuilt 1961 · S/N 22-8245 N4704HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283966 N4704ZRegistration Pending · Canyon Country, CARegistration pendingBuilt 1961 · S/N 22-8246 N47053Semagin Arkadi · Burlingame, CABuilt 1979 · S/N 15283163 N4705HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283967 N4705QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 152-85053 N4706ZAirsmith Aviation LLC · Oshkosh, WIS/N 22-8248 N4707LJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 15284222 N4707ZBradsher Larry Flint · Rougemont, NCBuilt 1961 · S/N 22-8250 N470AMSoutheast Lsa LLC · Jacksonville, FLS/N 20-0047 N470DWWhitesell Paul Trustee · Plano, TXBuilt 1973 · S/N AA1B-0255 N47108Ace Aircraft Leasing Inc · Nazareth, PABuilt 1979 · S/N 15283170 N4711BPinnacle Aviation Services Inc · Encinitas, CABuilt 1979 · S/N 15283591 N4711LWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284223 N4711ZHanna David A · Keene, TXS/N 22-8261 N47120Shipe Jacqueline M · Louisville, TNBuilt 1979 · S/N 15283174 N4712CPershing Todd Clark · Jacksonville, ORBuilt 1947 · S/N 12-3989 N47133Sunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283178 N4713BSmith Peter J · Excelsior, MNBuilt 1979 · S/N 15283593 N4713ZFailing Amanda R · Wasilla, AKBuilt 1961 · S/N 22-8257 N4715ZMuehlberg Stephen E · Newcastle, OKBuilt 1961 · S/N 22-8259 N4717BCoastal Flight Inc · Tierra Verde, FLBuilt 1979 · S/N 15283595 N47189Xclusive Level Aircraft World LLC · Kissimmee, FLS/N 15283183

Back to AD 80-25-02 R2