Skip to content

Registered aircraft · 47,133

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443 N3944YBrown Pelican Aviation LLC · Ralston, NEBuilt 1964 · S/N 21058444 N3945DBarnett Lance · Fairfield, CAS/N 34645 N39466Xing Kong Aviation Service LLC · Atwater, CABuilt 1978 · S/N 34-7870379 N3946QSwihart Matthew · Hood River, ORBuilt 1973 · S/N 18502213 N3946YMorris Steven A · Houston, TXBuilt 1964 · S/N 21058446 N39476Neal John W · Pt Pleas Bch, NJBuilt 1978 · S/N 28R-7803348 N39477Marti Michael · Kasson, MNBuilt 1978 · S/N 28R-7803349 N3947DBellew James W · Pueblo West, COBuilt 1957 · S/N 34647 N3947YRafter Jm Enterprises LLC · Swink, OKBuilt 1964 · S/N 21058447 N3948YSwine Management Service Inc · Long Island, KSBuilt 1964 · S/N 21058448 N3949MMatthews Devon · San Jose, CABuilt 1978 · S/N 28R-7803204 N394CCRoco Air LLC · San Antonio, TXBuilt 2004 · S/N 1395 N394CPN394cp LLC · Pinehurst, NCBuilt 2008 · S/N 3079 N394JMHigh Steaks Aviation LLC · Ragley, LABuilt 2019 · S/N 4839 N394MACulver Robert L · Alpharetta, GABuilt 2014 · S/N T24002034 N394MCRegistered aircraftBuilt 1969 · S/N TE-755 N394MKTtc Travel LLC · Terre Haute, INBuilt 2015 · S/N 4299 N394SJFlinn Patrick R · Reeds Spring, MOBuilt 2005 · S/N 1296 N394TAikens George · Greeley, COS/N TC-854 N394TAN4468n LLC · Cheyenne, WYBuilt 2023 · S/N 9211 N394WTMorgan Edmund Neal · San Diego, CABuilt 2002 · S/N 0165 N39501Jw & Jl Aviation LLC · Phoenix, AZBuilt 1982 · S/N U206-06452 N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450 N3951XLucky 20 Gourmet And Adventure Club LLC · Syracuse, INBuilt 1975 · S/N 34-7670003 N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451 N39522United States Air Force Elmendorf Aero Club · Elmendorf Afb, AKBuilt 1978 · S/N 34-7870385 N3952ARegistered aircraftBuilt 1969 · S/N D-9090 N39530Carroll Aaron W · Sarasota, FLBuilt 1978 · S/N 34-7870386 N39535Flight Services Inc · Headland, ALBuilt 1978 · S/N 28R-7837302 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 N39568James David Wayne · Odessa, TXBuilt 1978 · S/N 28R-7803355 N3956DJohnson Justin R · Bonners Ferry, IDS/N 34656 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 N39592Paratus Air Inc · Auburn, INFirst renewal noticeBuilt 1978 · S/N 34-7870395 N39594J Airco LLC · Nashville, TNBuilt 1978 · S/N 34-7870396 N3959DRandolph Clinton A · Bullhead City, AZBuilt 1957 · S/N 34659 N3959POmaha Aircraft LLC · Blair, NES/N P21000075 N3959YRabeneau Dale · Copperopolis, CABuilt 1964 · S/N 21058459 N395CDSimpson Russell · Nantucket, MABuilt 2005 · S/N 1263 N395CPVallencourt Jonathan Daniel · Green Cove Springs, FLBuilt 2008 · S/N 3149 N395DATriton Polaris LLC · Suwanee, GABuilt 2026 · S/N 11399 N395EUDodson Building Group LLC · Kalispell, MTBuilt 2011 · S/N E-3951 N395JJCate Kyle T · Johnstown, COBuilt 1978 · S/N 34-7870393

Back to AD 2000-23-21