Skip to content

Registered aircraft · 6,915

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

N4687JPletcher Enterprises Inc · Muscatine, IABuilt 1968 · S/N 28R-30589 N4689JFlynn Charles F · Helena, MTBuilt 1968 · S/N 28R-30591 N468PMEarspasm LLC · Brooklyn, NYBuilt 1972 · S/N 28R-7335041 N4691FBelk William E · Labelle, FLBuilt 1976 · S/N 32R-7680474 N4692JDingbat Ltd · Wilmington, DEBuilt 1968 · S/N 28R-30595 N4695JGrimm Jason Eddison · Sacramento, CAS/N 28R-30598 N4696JRegistered aircraftBuilt 1968 · S/N 28R-30599 N4698JShea William Preston · Franklin, TNBuilt 1968 · S/N 28R-30601 N4699JBeach Robert E · Fairfax, VABuilt 1968 · S/N 28R-30602 N469DLuxury Aviation LLC · Butler, PABuilt 1977 · S/N 32R-7880030 N469LPWilkins Paul T · Murrieta, CAS/N 34-8070106 N46CBSkylance Ventures LLC · Riverside, CABuilt 1977 · S/N 32R-7780481 N46EAEssential Aviation LLC · Meridianville, ALBuilt 1970 · S/N 39-79 N46MJones Gregory D · Pueblo, COBuilt 1958 · S/N 24-411 N46PHarrison Donna J · Eau Claire, MIBuilt 1966 · S/N 24-4470 N46UTVon Schmidt Gordon D · Waretown, NJBuilt 1973 · S/N 28R-7435068 N4711YAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28R-7335424 N47227N47227 Inc · Hobe Sound, FLBuilt 1977 · S/N 28R-7737158 N47228Sg Holdings LLC · Grand Mound, IABuilt 1977 · S/N 28R-7703354 N47232Lensis Thomas M · Wilmington, NCBuilt 1977 · S/N 32R-7880001 N47337Beatty William Keith · Lakeland, FLBuilt 1977 · S/N 28R-7737159 N47339Grider Aviation Inc · Indianapolis, INS/N 28R-7703357 N47342Buckley Air LLC · Plymouth, MABuilt 1977 · S/N 32R-7880002 N47347Alaska Yukon Aviation Ministries Inc · Anchorage, AKBuilt 1977 · S/N 34-7770387 N47359Mcilquham Roderick L · Bolingbrook, ILBuilt 1977 · S/N 28R-7703361 N47361Magpie Inc · Rock Springs, WYBuilt 1977 · S/N 28R-7703363 N47366Turbo Aviation LLC · Marblehead, MABuilt 1977 · S/N 34-7770389 N47404Mil2atp Inc · Pikeville, NCBuilt 1977 · S/N 34-7770392 N47416Jarriel Investments Inc · Register, GABuilt 1977 · S/N 28R-7703373 N47418Billings Chris · Duncan, OKBuilt 1977 · S/N 28R-7703374 N47419Capp Kevin C · Boswell, PABuilt 1977 · S/N 28R-7703375 N47423Synergy Wellness Group Inc · Bakersfield, CABuilt 1977 · S/N 32R-7880006 N47424Phoenix Aviation LLC · Alexandria, VAS/N 34-7770394 N4742FShinkle Mark R · Maitland, FLBuilt 1976 · S/N 32R-7680475 N4743MMcbride Paul · Dallas, TXBuilt 1969 · S/N 301848 N47442Registration Pending · Columbus, NERegistration pendingS/N 28R-7703377 N47445Premier Capital Enterprises LLC · Hurricane, UTBuilt 1977 · S/N 28R-7703379 N47448Jib Inc · Groton, CTBuilt 1977 · S/N 34-7770396 N47459Thompson James David · Newborn, GABuilt 1977 · S/N 28R-7703383 N47471Piper N47471 LLC · Granby, COBuilt 1977 · S/N 28R-7703384 N47484Sugarbaker Stephen J · Rocklin, CABuilt 1977 · S/N 28R-7737165 N47494Valiair Lc Trustee · Casper, WYS/N 28R-7737166 N47497Alpha Arrow Flying LLC · Iowa City, IABuilt 1977 · S/N 28R-7737168 N47498Strobel John D · Baltimore, MDBuilt 1977 · S/N 28R-7737169 N47501Route 66 Aviation Services LLC · Waynesville, MOBuilt 1977 · S/N 32R-7880010 N47514Groves William K · Faith, SDBuilt 1977 · S/N 28R-7703387 N47536Angel Aviation Inc · Peoria, AZBuilt 1977 · S/N 34-7770412 N47537Registered aircraftBuilt 1977 · S/N 34-7770413 N47546Robnett Theodore J · Central Point, ORBuilt 1977 · S/N 28R-7703395 N47551E2 Ventures Inc · Pinehurst, NCBuilt 1977 · S/N 28R-7703398

Back to AD 97-01-01 R1