Skip to content

Registered aircraft · 22,413

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.

N55485Cross Gary DBA · Commerce Twp, MIBuilt 1973 · S/N 28R-7335242 N5548FMueller Albert · Brookfield, WIBuilt 1968 · S/N 28-24886 N5548UMorales Ramos Abdiel · Tucson, AZBuilt 1969 · S/N 28-26272 N5548VShinny Air LLC · Lakeland, FLS/N 32R-7780344 N55497Murphy David B · Germantown, MDBuilt 1973 · S/N 28-7325419 N55498Burke Monte D · Dallas, TXBuilt 1973 · S/N 28-7325420 N5549JLombardi Steven · Edgewood, TXBuilt 1967 · S/N 32-1011 N5549UFar From Cheap LLC · Wichita Falls, TXBuilt 1969 · S/N 28-26273 N5549WFons Wlliam M · Oconomowoc, WIBuilt 1962 · S/N 28-640 N554FLTomenyaero Inc · Florence, ORS/N 28-7125393 N554LBSons Family Enterprises LLC · Wichita Falls, TXS/N 28-10250 N554PAGerken Nicholas C · Anacortes, WABuilt 1972 · S/N 28-7225475 N554PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842091 N554RRegistered aircraftBuilt 1976 · S/N 28-7690382 N55502Blue Valley Flying Club Inc · Denton, NES/N 28-7305401 N55504University Cherokee Club LLC · Lincoln, NEBuilt 1973 · S/N 28-7305402 N55505Bothwell Brandon W · Mooresville, MOS/N 28-7305403 N55506Lugo Rullan Javier A · Adjuntas, PRBuilt 1973 · S/N 28-7325424 N5550UFarm Air Service Inc · Pingree, NDBuilt 1969 · S/N 28-26274 N5550WStone Oren · Erick, OKS/N 28-641 N55513Spoon River Flyers Inc · Avon, ILBuilt 1973 · S/N 28-7305405 N55514Loomis Christopher · Cumming, GABuilt 1973 · S/N 28-7305406 N55516On Glideslope LLC · Middletown, DEBuilt 1973 · S/N 28R-7335247 N55517Loye Mark C · Reidsville, NCBuilt 1973 · S/N 28-7310146 N5551FFriest Eric J · Menomonie, WIBuilt 1968 · S/N 28-24890 N5551WMurdter Lawrence M · Sunnyvale, CABuilt 1962 · S/N 28-642 N55525Gustafson Michael Luther · Groveland, CABuilt 1973 · S/N 28-7325426 N55529Carrozzella Christopher · Wallingford, CTS/N 28-7305407 N55533Gw Aero LLC · Ponte Vedra Beach, FLBuilt 1973 · S/N 28R-7335249 N5553JHein Investments LLC · Omro, WIBuilt 1968 · S/N 32-1016 N5553UMcdonough Brian E · Harrisburg, PABuilt 1969 · S/N 28-26278 N55542Colorado Cherokee Flyers LLC · Boulder, COBuilt 1973 · S/N 28-7325429 N5554DValiair Limited Company Trustee · Casper, WYBuilt 1965 · S/N 28-2228 N5554EValiair Limited Company Trustee · Casper, WYBuilt 1977 · S/N 28-7725152 N5554JC M Lindsay And Sons Inc · Lumberton, NCBuilt 1968 · S/N 32-1017 N5554UNeeley Stephan B · Dighton, KSBuilt 1969 · S/N 28-26279 N5554WFlyworx LLC · Kalispell, MTBuilt 1962 · S/N 28-646 N55551Mahmud Fawzi S · Enid, OKBuilt 1973 · S/N 28-7325328 N55558Wagner Mark · Medina, WABuilt 1973 · S/N 28-7325368 N55559Mcconnachie Craig · Bullhead City, AZBuilt 1973 · S/N 28-7305392 N5555AGellner Sy D · Billings, MTS/N 28-860 N5555JSawyer James K · Odessa, FLBuilt 1968 · S/N 32-1019 N5555WLemieux Patrick · San Luis Obispo, CABuilt 1962 · S/N 28-647 N55563Sanchez Alejandro Arturo · El Paso, TXBuilt 1973 · S/N 28-7325433 N55564Moore Ryan J · Corvallis, ORBuilt 1973 · S/N 28-7305414 N55565Brickweg Kurt J · Cincinnati, OHBuilt 1973 · S/N 28-7305415 N55566Speck G Dan · Roaring Spring, PABuilt 1973 · S/N 28R-7335252 N5556UCynthiana Flying Group Corp · Cynthiana, KYBuilt 1969 · S/N 28-26282 N55578Gardiner Merrill L · Traverse City, MIBuilt 1973 · S/N 28-7325435 N55585Kankakee Area Flying Group LLC · Gilman, ILBuilt 1973 · S/N 28-7305418

Back to AD 87-08-08 R3