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.

N8446RKonyndyk John R · Muskegon, MIBuilt 1966 · S/N 28-22330 N84474Young John R · Rockland, MABuilt 1981 · S/N 28-8216028 N84478Shg Holdings LLC · Greer, SCBuilt 1981 · S/N 28-8211015 N8447FPerry Bros · Fort Branch, INBuilt 1976 · S/N 28-7725112 N8447HJ & J Farms LLC · Oakman, ALBuilt 1981 · S/N 28-8211008 N8447WVelasquez Timothy · Midlothian, TXBuilt 1965 · S/N 28-2680 N84481Knopp Kathy · Virginia Beach, VABuilt 1981 · S/N 32R-8129113 N8448AHughes Patrick J · Saint Augustine, FLBuilt 1981 · S/N 28-8290037 N8448CWoodburn Brian · Glenpool, OKBuilt 1981 · S/N 28R-8231003 N8448RJohnson Jeffrey Harold · Saint Cloud, MNBuilt 1966 · S/N 28-22333 N8448WFlight 209er LLC · Sharpsburg, GABuilt 1965 · S/N 28-2654 N8448YDesert Green Turf Inc · Moses Lake, WABuilt 1981 · S/N 32R-8129111 N8448ZBliss Air LLC · Saint Joseph, MIBuilt 1981 · S/N 32R-8129112 N8449ZTrim Michael N · East Elmhurst, NYBuilt 1981 · S/N 28-8216030 N844ABParkland College · Champaign, ILBuilt 2020 · S/N 2881426 N844TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020144 N84500Bank Of Perry County · Lobelville, TNBuilt 1981 · S/N 32R-8113120 N8450DGao LLC · Hoover, ALBuilt 1981 · S/N 28-8290039 N8450GPuryear Eric D · Bettendorf, IABuilt 1981 · S/N 28-8290040 N8450SKyle Steven L · Newcastle, CABuilt 1981 · S/N 28-8290043 N8450TWaterhouse Mark R · Mays Landing, NJBuilt 1981 · S/N 28-8211011 N8451BBmw Air LLC · Norwalk, IABuilt 1981 · S/N 32R-8113121 N8451FBecker Thomas · Wisconsin Rapids, WIBuilt 1976 · S/N 28-7715263 N8451WN8451 LLC · Seymour, TXBuilt 1965 · S/N 28-2686 N84527Registration Pending · Cole Camp, MORegistration pendingBuilt 1981 · S/N 28-8290045 N84528Northstar Aviation Inc · Howell, MIBuilt 1981 · S/N 28-8290046 N8452BK & K Commercial Leasing LLC · Indiana, PABuilt 1981 · S/N 28-8216039 N8452HMacorix Transport LLC · Newark, NJS/N 28-8216040 N8452RHerbert Aviation LLC · Saginaw, MIS/N 28-8216041 N8452WVentura Shelley A · Grayslake, ILBuilt 1981 · S/N 28-8290044 N8453BMinerva Michael M · Saint Augustine, FLBuilt 1981 · S/N 28-8290047 N8453WHub City Aviation Academy LLC · Lubbock, TXBuilt 1965 · S/N 28-2688 N8454ACannon Air Force Base Aero Club · Clovis, NMBuilt 1981 · S/N 28-8216046 N8454BInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8216047 N8454EKompass Aviation LLC · Sheridan, WYBuilt 1999 · S/N 3257096 N8454FCaspersen Lars C · Bloomsburg, PABuilt 1976 · S/N 28-7715266 N8454HPilots Flying School LLC · Englishtown, NJBuilt 1981 · S/N 28-8290050 N8454NF R E Investments LLC · Enterprise, ALS/N 28-8290051 N8454RGlobal Agriculture Commodities LLC · Brooklet, GABuilt 1981 · S/N 32-8106097 N8455DGrediagin Wayne S · Anchorage, AKBuilt 1981 · S/N 32R-8229003 N8455FHill City Aviation LLC · Concord, VABuilt 1981 · S/N 32R-8229004 N8455HDavidson James A · Frisco, TXBuilt 1981 · S/N 32R-8229005 N8455RHorizon Flyers LLC · Kingsford, MIS/N 28-22356 N8455WTroxell Martha A · Indiana, PABuilt 1965 · S/N 28-2691 N84577Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1981 · S/N 28-8216052 N8457FRandom Bit LLC · Monroe, NCBuilt 1976 · S/N 32R-7780101 N84585Maginn Conor · Lakeland, FLBuilt 1981 · S/N 32-8206005 N8458HGansemer William L · Mason City, IABuilt 1981 · S/N 28-8290053 N8458RBauer Bradley R · Larchwood, IABuilt 1966 · S/N 28-22360 N8459BTailwinds Logistics LLC · Port Orange, FLBuilt 1981 · S/N 32R-8213003

Back to AD 87-08-08 R3