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.

N9478NChadwick Aviation Services LLC · Monroe, CTBuilt 1969 · S/N 28R-35196 N9478WAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1968 · S/N 28-11211 N9479WSchacher Daniel E · Muleshoe, TXBuilt 1968 · S/N 28-11213 N9480CDave Gross Inc · Midland, TXBuilt 1978 · S/N 28-7816480 N9480J217 Moriarty LLC · Stonewall, MSBuilt 1966 · S/N 28-3597 N9480NHernandez Luis · Surprise, AZS/N 28R-35198 N9481JRuffner Samuel D · Powder Springs, GABuilt 1966 · S/N 28-3598 N9481KHepp Investments LLC · Warrens, WIBuilt 1976 · S/N 28-7615205 N9481NKing Cindy · Purvis, MSBuilt 1969 · S/N 28R-35199 N9481WMcintyre Stephen C · Lumberton, NCBuilt 1968 · S/N 28-11216 N9482CSchuetz Ray · Davie, FLBuilt 1978 · S/N 28-7816481 N9482WCantrall Aviation Flying Club LLC · Elizabethtown, KYBuilt 1968 · S/N 28-11218 N9483CCnczilla Co · Royersford, PABuilt 1978 · S/N 28-7816482 N9483WFlying D Aviation Of Kansas LLC · Wichita, KSBuilt 1969 · S/N 28-11221 N9484KDoll Electric Co Inc · South Lake Tahoe, CABuilt 1976 · S/N 28-7615206 N9484NBourjeili Elias · Glendora, CABuilt 1969 · S/N 28R-35202 N9485JBlakely Jerry II · Coeur D Alene, IDBuilt 1966 · S/N 28-3602 N9486CRhodes Ryan · Dallas, TXBuilt 1978 · S/N 28-7890415 N9486JJames Andy K · Shallowater, TXBuilt 1966 · S/N 28-3603 N9486KAerial Avionics Inc · Modesto, CABuilt 1976 · S/N 28-7615207 N9486NRahimi Navid B · Silver Spring, MDBuilt 1969 · S/N 28R-35205 N9487JElmenhurst Daniel D · Walla Walla, WABuilt 1966 · S/N 28-3604 N9487KInverted Air LLC · Mesa, AZBuilt 1976 · S/N 28-7690254 N9487WPikes Peak Fliers LLC · Colorado Springs, COBuilt 1968 · S/N 28-11226 N9488JSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 28-3605 N9489JIndiana County Flying Club Inc · Blairsville, PABuilt 1966 · S/N 28-3606 N9491JRoy Thomas M Jr · Carbondale, ILBuilt 1966 · S/N 28-3609 N9491NWalker Mark L · Turlock, CABuilt 1969 · S/N 28R-35212 N9491WPathfinder 91w LLC · Big Sky, MTBuilt 1969 · S/N 28-11231 N9492NKnaust Kurt · Baldwinsville, NYBuilt 1969 · S/N 28R-35213 N9492WHixson Robert S · Los Alamos, NMBuilt 1969 · S/N 28-11232 N9493JHayes Enterprises · Glendale, AZBuilt 1966 · S/N 28-3611 N9493NHigh Prairie Aviation LLC · Washington, IABuilt 1969 · S/N 28R-35214 N9494CChristensen Robert R · Mattawa, WABuilt 1978 · S/N 32-7840099 N9494JRuiz Serge · Montgomery, TXS/N 28-3613 N9494WDavisson Michael A · Edgewood, NMBuilt 1969 · S/N 28-11234 N9495NNagel Richard A · Mequon, WIBuilt 1969 · S/N 28R-35216 N9496WJones Terry · Bells, TNBuilt 1969 · S/N 28-11238 N9497JShushnar Gary J · Irvine, CABuilt 1966 · S/N 28-3737 N9497WArnold Thomas A · Appleton, MNBuilt 1969 · S/N 28-11239 N9498JBrantley Hugh L · Hazlehurst, GAS/N 28-3738 N9498KDirksen Caleb A · Garner, IABuilt 1976 · S/N 28R-7635245 N9498NKoehler Scott A · Brighton, ILBuilt 1969 · S/N 28R-35219 N9499NFlight Niner Niner LLC · Charleston, SCBuilt 1969 · S/N 28R-35220 N949GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881225 N94AKWestern Aviation LLC · Bloomfield, MIBuilt 1996 · S/N 32-46043 N94DCaelesti Libertas LLC · Pittsford, NYBuilt 1982 · S/N 32R-8229050 N94DLWhiskey November Aviation LLC · Minneapolis, MNBuilt 1973 · S/N 28-7415076 N94NARegistration Pending · Northampton, MARegistration pendingS/N 2844003 N94PLucas Matthew A · Mission Viejo, CABuilt 1969 · S/N 32-40660

Back to AD 87-08-08 R3