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.

N373LEWoodley Judson · Comanche, TXS/N 73-30530 N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887 N373STLassen Peter C · Ventura, CAS/N EA-308 N37402Viking Construction Inc · Hayden Lake, IDBuilt 1980 · S/N EA-165 N3740YOmg Air LLC · Okeechobee, FLBuilt 1964 · S/N 21058240 N3741BCherokee Trail Aviation LLC · Tontitown, ARBuilt 1980 · S/N E-1722 N3741COmr Investments LLC · Dawson, GABuilt 1980 · S/N E-1757 N3742QVives David A · Valdosta, GABuilt 1967 · S/N CE-140 N3743YCooper Jess D · Spanaway, WAS/N 21058243 N3744GValiair Limited Co Trustee · Casper, WYBuilt 1977 · S/N 310R0909 N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052 N3746Nickravesh Niknam J · Saratoga, CABuilt 1975 · S/N U20602818 N3746YWeed James A · Suwanee, GABuilt 1963 · S/N 21058246 N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818 N3747QWolff Charles L · Pensacola, FLBuilt 1967 · S/N TE-307 N3747TAir Force One LLC · Coral Springs, FLBuilt 2005 · S/N 1328 N3747YCenturion Aviation Nevada LLC · Sparks, NVBuilt 1963 · S/N 21058247 N3748HVoth Michael K · Lynchburg, VABuilt 1963 · S/N 21058248 N3748QThoendel Jason · Saint Charles, MOBuilt 1967 · S/N D-8411 N3749YWestwind Homes Inc · Twin Falls, IDBuilt 1963 · S/N 21058249 N374CDN374cd LLC · Goffstown, NHBuilt 2004 · S/N 1174 N374TOtt James D · Kilgore, TXBuilt 1966 · S/N D-8165 N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105 N3750YMurphy Mark · Belleair, FLBuilt 1963 · S/N 21058250 N3752CMiller Robert G · Clear Lake, IAS/N 414-0819 N3753QMintz Jason · Houston, TXBuilt 1967 · S/N D-8393 N3753YWolfe Christopher D · Gilbert, AZBuilt 1963 · S/N 21058253 N3754YSullivan Eugene M · Cotter, ARBuilt 1963 · S/N 21058254 N3755YCecil Enterprises LLC · Gig Harbor, WABuilt 1963 · S/N 21058255 N3756XStephens Tanner B · Palmer, AKBuilt 1968 · S/N 21059075 N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839 N3759QJ & C Companies LLC · Mesa, AZBuilt 1967 · S/N D-8394 N3759YManagement Support Services LLC · Naturita, COBuilt 1963 · S/N 21058259 N375CDAtlantic Marine Construction Co Inc · Virginia Beach, VABuilt 2005 · S/N 1461 N375FDepartment Of The Interior · Boise, IDBuilt 1980 · S/N U20605750 N375HPCraig E Rappe · Wasilla, AKBuilt 1976 · S/N 18503235 N375HWWallace Charles · Fayetteville, ARBuilt 1963 · S/N 21058251 N375JWPanthers Aviation LLC · Pikeville, KYBuilt 1995 · S/N E-2918 N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226 N375LMiroyan Robert Trustee · San Jose, CABuilt 1973 · S/N E-427 N375MKIntegrity S&J Properties LLC · Amarillo, TXBuilt 1963 · S/N 21058252 N375PWRyan Adrian B · Anchorage, AKBuilt 1979 · S/N 18503965 N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468 N375RBMarinella Leasing LLC · Chandler, AZBuilt 1998 · S/N E-3155 N375WVictory Holdings LLC · Anacortes, WABuilt 1978 · S/N 18503598 N3760YHarris Stephen T · Williamstown, KYBuilt 1963 · S/N 21058260 N3761PSky Rollers LLC · Merritt Island, FLBuilt 1978 · S/N P21000053 N3762QHarris Randal Glenn · Sedona, AZS/N D-8398 N3763QOrr Robert · San Clemente, CABuilt 1967 · S/N D-8399 N3765QTonry Richard Martin · Georgetown, TXBuilt 1967 · S/N CE-139

Back to AD 86-13-04 R3