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.

N9230WLorenti Anthony Charles · Meriden, CTBuilt 1967 · S/N 28-10898 N9231JLeetz Tom · Elgin, ILBuilt 1966 · S/N 28-3302 N9232JAdirondack Flying Club LLC · Rome, NYBuilt 1966 · S/N 28-3305 N9232WBarnum Eric E Trustee · Maumee, OHBuilt 1967 · S/N 28-10900 N9233WMount Up Aviation LLC · Kirbyville, MOBuilt 1967 · S/N 28-10901 N9233ZCalmwinds LLC · Middletown, DEBuilt 1993 · S/N 3213062 N9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232 N9234WRutledge Brent E · Uvalde, TXBuilt 1967 · S/N 28-10902 N9234ZIovanna Steven · Plymouth, MABuilt 1995 · S/N 2811041 N9235CWilliams Patrick S · Saint Paul, MNBuilt 1978 · S/N 28-7890392 N9235QInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N 3213072 N9236CRudloff Uwe K · Lake Village, INBuilt 1978 · S/N 28R-7837181 N9236JThunderbird Air LLC · Grand Rapids, MIBuilt 1993 · S/N 3213067 N9236KLabrada Fabio · Decatur, TXBuilt 1976 · S/N 28-7625172 N9236NWilliams Robert J · Sewickley, PABuilt 1993 · S/N 3213068 N9236VYeske Brock Ray · Peoria, ILBuilt 1993 · S/N 3213069 N9236WSchmidt Robert · Winchester, WIBuilt 1967 · S/N 28-10905 N9237JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841123 N9237WDoyle Michael J II · Wakeman, OHBuilt 1967 · S/N 28-10877 N9238KCrow Wing Flying Club Corp · Nisswa, MNFirst renewal noticeBuilt 1976 · S/N 28-7690233 N9238WMansour Muhamad A · Wichita, KSBuilt 1967 · S/N 28-10908 N92390Elek LLC · Springfield, MOBuilt 1994 · S/N 2811045 N9239DMisson Aviation LLC · Lima, OHBuilt 1994 · S/N 3213071 N9239JAshmore Benjamin H Jr · Austin, TXBuilt 1966 · S/N 28-3313 N9239NRd Aviation LLC · Fort Lauderdale, FLBuilt 1993 · S/N 3213070 N9239WBenrud Jeffrey S · Raeford, NCBuilt 1967 · S/N 28-10909 N9240JThorson Jason J · East Grand Forks, MNBuilt 1966 · S/N 28-3314 N9240KHolland Wyatt Eugene · Garner, IAS/N 28-7690234 N9241WAnderson Fred M · Cocoa, FLBuilt 1967 · S/N 28-10911 N9242JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3316 N9242WAllison Richard H Jr · Livingston, TXBuilt 1967 · S/N 28-10912 N9243JRoney Edward A · Weirton, WVBuilt 1966 · S/N 28-3318 N9244JRichardson David M · Dwight, ILS/N 28-3319 N9244WCogan Michael Benjamin · San Jose, CABuilt 1967 · S/N 28-10914 N9245WN9245w Partnership · Lumberton, MSS/N 28-10915 N9246FFischer Alfred M · Genoa City, WIBuilt 1989 · S/N 2841254 N9246JMckool John Jr · Johnstown, PABuilt 1966 · S/N 28-3321 N9246KN9246k Corp LLC · Federal Way, WAFirst renewal noticeBuilt 1976 · S/N 28-7615189 N9247JGreco Timothy F · Sewell, NJBuilt 1966 · S/N 28-3322 N9248KGerstner Michael J · Ola, ARBuilt 1976 · S/N 28-7690236 N9248WMeyers Andrew W · San Ramon, CABuilt 1967 · S/N 28-10918 N924DBFlying Veterans Club Of San Francisco Inc · Belmont, CABuilt 1973 · S/N 28-7305198 N924JCCroman Graham P · Clayton, GAFirst renewal noticeBuilt 1977 · S/N 28R-7703196 N924KAEvanoff Mark Alan · Saint Augustine, FLBuilt 1965 · S/N 28-21295 N924NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881886 N924RRHigh Timothy Duane · Glenwood, MOBuilt 1977 · S/N 32R-7780450 N924SMRed Rock Flying School LLC · Mesa, AZBuilt 1976 · S/N 32R-7680090 N92500Romeo Charlie Aviation LLC · Stuart, FLBuilt 1994 · S/N 2890207 N92505Thunderbird Aviation Inc · Bloomington, MNBuilt 1994 · S/N 2890211 N9250CRegion Flyers LLC · Valparaiso, INBuilt 1978 · S/N 28-7816451

Back to AD 87-08-08 R3