Skip to content

Registered aircraft · 72,010

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N4473RMiller Keith A · Reedy, WVBuilt 1974 · S/N 17263215 N4473XSlipstream Aviation LLC · Calera, ALBuilt 1975 · S/N 28-7690018 N4473ZEriksen Rodney B Trustee · Juneau, AKBuilt 1969 · S/N 18-8822 N44746Kline William D Trustee · Chesterfield, MOBuilt 1974 · S/N 28-7510001 N44747Goldenburg Timothy A · Ypsilanti, MIBuilt 1974 · S/N 32-7500001 N44749Hoprich Jeffrey S · Roanoke, VABuilt 1974 · S/N 28-7515021 N4474FN44107 LLC · Marlton, NJBuilt 1976 · S/N 28-7790029 N4474XToledo City School District · Swanton, OHS/N 28R-7635054 N4474ZWatts Craig W · Incline Village, NVBuilt 1969 · S/N 18-8824 N44753Registration Pending · Torrance, CARegistration pendingBuilt 1974 · S/N 28-7505006 N44754Greenville Pickens Roundtrac LLC · Easley, SCBuilt 1974 · S/N 28R-7535003 N44755Argosy Venture Corp · Pagosa Springs, COBuilt 1974 · S/N 28-7510002 N4475JHilburn Brian · Philadephia, PABuilt 1967 · S/N 28-22891 N4475PRamaswamy Gautam · Clearwater, FLBuilt 1961 · S/N 23-1997 N4475RBrown Charles A · Portland, TXBuilt 1978 · S/N R18200604 N4475TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250106 N44761Henderson Gregory S · Saltsburg, PABuilt 1974 · S/N 28-7515025 N44763Flying Peanuts LLC · Wilmington, DEBuilt 1974 · S/N 28-7505007 N44764Hess Alex · American Fork, UTBuilt 1974 · S/N 28-7505008 N4476ZS And C Flying LLC · Pierre, SDS/N 18-8827 N44771Benedict Kevin M · Lakeland, FLBuilt 1974 · S/N 28-7525003 N44772Hanson Donald H · Bellevue, WABuilt 1974 · S/N 28-7515028 N44773Nair Vihas G · Philadelphia, PABuilt 1974 · S/N 28-7515029 N44775Heuerman Jordan D · Casey, ILBuilt 1974 · S/N 28-7515030 N44777Delisi Carl V · Linden, MIS/N 28-7510004 N4477ABrown Danny J · Skidmore, MOBuilt 1956 · S/N 18-4833 N4477PAirknocker Inc · Wilmington, DEBuilt 1960 · S/N 25-253 N44780Imler Jarrod M · Gallatin, TNBuilt 1975 · S/N 28-7510005 N44782Alsup Jonathan S · Tok, AKBuilt 1974 · S/N 32-7500002 N44783Family Eye Care Center LLC · Elkins, WVBuilt 1974 · S/N 32-7540004 N44786Flight Academy LLC · Van Nuys, CAS/N 28-7515032 N44789Dzialo Matthew J · Pawtucket, RIBuilt 1974 · S/N 28-7505011 N4478AOrth Henry J · Wasilla, AKBuilt 1956 · S/N 18-4835 N4478JFly 500 LLC · Fort Pierce, FLBuilt 1967 · S/N 28-22894 N4478TSchroder David A · Venice, FLBuilt 1972 · S/N 28-7205168 N4478XWhite Raymond W · Montrose, MIBuilt 1975 · S/N 28-7615017 N44790Spence William M · Naples, FLBuilt 1974 · S/N 28R-7535007 N44792Ocean Air Inc · Eugene, ORBuilt 1974 · S/N 28-7515064 N4479RUp And Up Aviation LLC · Magnolia, TXS/N 17263221 N4479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1972 · S/N 28R-7235033 N4479YKnutson Wayne R · Tioga, NDBuilt 1966 · S/N 25-4108 N4479ZHardan Weston W · Palmer, AKBuilt 1969 · S/N 18-8834 N447BAHc01 LLC · Vero Beach, FLBuilt 2013 · S/N 2263 N447BBFerree William M · Stafford Springs, CTBuilt 2017 · S/N 71509 N447BDRegistration Pending · Columbia, KYRegistration pendingBuilt 2009 · S/N 60103 N447CFBleecker Lee M · Dousman, WIBuilt 1995 · S/N 0218 N447GHorn Rodney L · Friendswood, TXBuilt 2008 · S/N 72825 N447HHartz Paul · Lake Suzy, FLBuilt 2002 · S/N 169 N447JCConner Jeff · Findlay, OHBuilt 2026 · S/N 41739 N447KSPoletto Danny A · Great Falls, MTBuilt 1969 · S/N 28-25439

Back to AD 87-10-06 R1