Skip to content

Registered aircraft · 18,497

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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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.

N392SPlocher Corey · Port Orchard, WABuilt 1968 · S/N D-8752 N3936GBaker George G · Junction City, ORBuilt 1976 · S/N 340A0237 N3939GThree Niner Gulf L L C · Denver, COBuilt 1967 · S/N U206-0939 N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261 N393FBRegistered aircraftBuilt 2002 · S/N TH-2026 N393MPDutch Indian Air LLC · Riverdale, CABuilt 1976 · S/N 421C0203 N393PSVein C Jason · Riviera Beach, FLBuilt 2005 · S/N 29-0393 N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442 N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443 N3944YBrown Pelican Aviation LLC · Ralston, NEBuilt 1964 · S/N 21058444 N3946QSwihart Matthew · Hood River, ORBuilt 1973 · S/N 18502213 N3946YMorris Steven A · Houston, TXBuilt 1964 · S/N 21058446 N3947YRafter Jm Enterprises LLC · Swink, OKBuilt 1964 · S/N 21058447 N3948YSwine Management Service Inc · Long Island, KSBuilt 1964 · S/N 21058448 N394MCRegistered aircraftBuilt 1969 · S/N TE-755 N394SJFlinn Patrick R · Reeds Spring, MOBuilt 2005 · S/N 1296 N394WTMorgan Edmund Neal · San Diego, CABuilt 2002 · S/N 0165 N39501Registration Pending · Phoenix, AZRegistration pendingBuilt 1982 · S/N U206-06452 N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450 N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451 N3952ARegistered aircraftBuilt 1969 · S/N D-9090 N3953PSowards David C · Fairbanks, AKBuilt 1976 · S/N 18503090 N3953QQueen Anne Air LLC · Seattle, WAS/N 18503422 N3954AVasil Christopher J · Los Gatos, CABuilt 1970 · S/N CE-308 N3954YStone Clifford F Jr · Corning, CABuilt 1964 · S/N 21058454 N3956YWilliams John S · Fort Walton Beach, FLBuilt 1964 · S/N 21058456 N3957ARegistration Pending · Denton, TXRegistration pendingBuilt 1970 · S/N D-9186 N3957YRegistration Pending · Midland, TXRegistration pendingBuilt 1964 · S/N 21058457 N3958AHinton Richard D · Colleyville, TXBuilt 1970 · S/N D-9194 N3959POmaha Aircraft LLC · Blair, NES/N P21000075 N3959YRabeneau Dale · Copperopolis, CABuilt 1964 · S/N 21058459 N395CDSimpson Russell · Nantucket, MABuilt 2005 · S/N 1263 N395EUDodson Building Group LLC · Kalispell, MTBuilt 2011 · S/N E-3951 N395LMMj&J LLC · Dodge City, KSBuilt 2005 · S/N 1395 N395SAFmco Promotions Inc · North Little Rock, ARBuilt 2000 · S/N E-3313 N3960YSeals Clinton F · Warren, ORBuilt 1964 · S/N 21058460 N3961YSmith Edward C · Lecompton, KSBuilt 1964 · S/N 21058461 N3962GJoe Sanchez Farms Inc · Walnut Grove, CABuilt 1967 · S/N U206-0962 N3967YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058467 N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037 N3968YDetray Michael S · Roy, WAFirst renewal noticeBuilt 1964 · S/N 21058468 N3969QRegistration Pending · Greeley, CORegistration pending, canceledBuilt 1974 · S/N 18502216 N3969YCayce Dick Lon Jr · Longview, TXS/N 21058469 N396BSpring Creek Financial Inc · Lewistown, MTBuilt 1992 · S/N EA-537 N396RPPelfrey Rosemarie · Choctaw, OKBuilt 2011 · S/N E-3960 N3970GBack Country Flying Experience Inc · Kalispell, MTBuilt 1967 · S/N U206-0970 N3972GCounty Of Merced Sheriff'S Dept · Merced, CABuilt 1967 · S/N U206-0972 N3974GStaheli Lee E · Kiana, AKFirst renewal noticeS/N U206-0974 N3976GBeauboeuf Andre F · Center Sandwich, NHBuilt 1967 · S/N U206-0976 N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207

Back to AD 86-13-04 R3