Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N8402BMays Richard N · Lakeway, TXBuilt 1981 · S/N 28-8111080 N8402CConner W Larry · Los Lunas, NMBuilt 1976 · S/N 28-7625112 N8402RLivengood Leasing Co LLC · Mesa, AZBuilt 1966 · S/N 28-22279 N8402SHigh Noon Leasing LLC · Anchorage, AKBuilt 1981 · S/N 32-8106075 N8402WAnderson Thomas · La Quinta, CABuilt 1965 · S/N 28-2616 N8403BVolare Via LLC · Piqua, OHBuilt 1981 · S/N 32R-8113082 N8403DTelford Aircraft LLC · Telford, TNS/N 32R-8129078 N8403RSenmounnarath Sam · Murfreesboro, TNBuilt 1966 · S/N 28-22280 N8404CLudwick Paul W · Lighthouse Point, FLBuilt 1976 · S/N 28R-7635157 N84054Far Horizons LLC · Ravenel, SCBuilt 1981 · S/N 28-8116257 N8405BMiloud Chadd K · Fort Worth, TXBuilt 1981 · S/N 28-8116252 N8405MWilson Howard C · Georgetown, TXBuilt 1981 · S/N 28-8116254 N8405RShields Parker · Port Orange, FLBuilt 1966 · S/N 28-22345 N8405SAlston Tony · Midland, TXBuilt 1981 · S/N 28-8116255 N8405WTaylor Dale E · Kimball, SDBuilt 1965 · S/N 28-2621 N8406AColorado High Flyers LLC · Colorado Springs, COBuilt 1981 · S/N 28-8290017 N8406HP A Flying LLC · Pueblo, COFirst renewal noticeBuilt 1981 · S/N 28-8190269 N8406TCook Neal L · Anchorage, AKBuilt 1981 · S/N 28R-8131161 N8406WWright Jordan M · York, SCBuilt 1965 · S/N 28-2623 N8408BCharlton Gary R II · Loudonville, NYBuilt 1981 · S/N 28-8116258 N8408CDallas Secure Storage LLC · Dallas, ORBuilt 1976 · S/N 28-7625113 N8408ECandace A Larned Enterprises Inc · Long Beach, CABuilt 1981 · S/N 28-8116259 N8408LMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28-8116261 N8408RWilliams Christopher A · Kent, WAS/N 28-22285 N8409AWngz Aviation Apparel LLC · Sanford, FLBuilt 1981 · S/N 32R-8113084 N8409HAerocolibri LLC · Nampa, IDBuilt 1981 · S/N 32R-8129084 N8409RRatliff Christopher · Manteno, ILBuilt 1966 · S/N 28-22286 N8409WMessam Andre · Snellville, GABuilt 1965 · S/N 28-2626 N8409YRivera William Carl · Silver Spring, MDBuilt 1981 · S/N 32R-8129086 N840CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2844182 N840DXPiper Aircraft Inc · Vero Beach, FLBuilt 2024 · S/N 2881826 N840TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842416 N840UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020194 N840WMKunzelmann Christopher E · Weatogue, CTBuilt 1966 · S/N 32-711 N84109Bielak Donald · Louisburg, KSBuilt 1981 · S/N 28-8290034 N8410CLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7615105 N8410SNorth Shelby Aviation LLC · Wilmington, DEBuilt 1981 · S/N 28-8116263 N8410WRenegade6 Aviation LLC · Woodbridge, VABuilt 1965 · S/N 28-2629 N8411BGrohs Dihl J · Wessington Springs, SDBuilt 1981 · S/N 28-8190275 N8411CRtb Aviation LLC · Jurupa Valley, CABuilt 1976 · S/N 28-7690136 N8411REleven Romeo LLC · Golden, COBuilt 1966 · S/N 28-22288 N8411WHiggins Timothy Owen · Axtell, TXS/N 28-2635 N8412BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 28R-8131164 N8412CEiler Marc · Seattle, WAS/N 28-7690137 N8412PCoastal Air LLC · Naknek, AKS/N 32-8106079 N8412RChamberlain Richard T · Collinsville, ILBuilt 1966 · S/N 28-22289 N8412WSutton Timothy A · Glencoe, ALS/N 28-2636 N8412ZVan Deman Frank L · Virginia Beach, VABuilt 1981 · S/N 32R-8113086 N8413CBrown Lawrence L · Millington, TNBuilt 1976 · S/N 28R-7635159 N8413RZuniga Hector Javier · Mission, TXBuilt 1966 · S/N 28-22290

Back to AD 87-08-08 R3