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.

N67JAJaars Inc · Waxhaw, NCBuilt 1980 · S/N U20605781 N67JVNext Gen Aviation LLC · Jenks, OKBuilt 1978 · S/N 421C0429 N67JWManley Steven T · Dallas, TXS/N E-1530 N67KWMunoz Rodolfo A Jr · Midland, TXBuilt 1967 · S/N TE-462 N67LRoad Kill Aviation Inc · Wilmington, DEBuilt 1973 · S/N TE-908 N67RCBueter Eric J · Wauseon, OHS/N D-8049 N67RKRiley Matthew · Xenia, OHS/N 310Q1107 N67RZModular Aviation LLC · Saratoga Springs, UTBuilt 1981 · S/N 414A0817 N67SAE And J Medical Consulting LLC · Lima, OHBuilt 2004 · S/N 0978 N67VBRegistration Pending · Athens, TNRegistration pending, pending cancellationBuilt 1967 · S/N D-8428 N67VMCreeque Alley Ventures LLC · Missoula, MTBuilt 1980 · S/N P21000568 N67WDWatson Frank · Canton, PABuilt 1966 · S/N 30015 N67WMNiles Air LLC · Concord, NCBuilt 2017 · S/N TH-2485 N67XLDavid E Morris Sr Enterprises LLC DBA · Mountainburg, ARBuilt 1983 · S/N P21000815 N6801SMastropole James W · Great Falls, VABuilt 1976 · S/N D-9849 N6801THoffman Peter · Monrovia, CABuilt 1984 · S/N EA-429 N6802RStahla Robert E Trustee · Grand Island, NEBuilt 1966 · S/N T210-0202 N6803RN6803r LLC · Kent, OHBuilt 1966 · S/N T210-0203 N6808SKlw Flight Management LLC · Booneville, MSS/N D-9852 N680JPPascale Jeannie Webb · Fairview, TXBuilt 2025 · S/N E-4160 N680PBoren John D · Martinsville, INBuilt 2005 · S/N 1441 N680RSSamples Ryan · Edmond, OKBuilt 1966 · S/N D-8298 N6810QFerraraccio Chris · Clarksville, TNBuilt 1964 · S/N D-7594 N6810SUsda-Aphis-Ppq · Edinburg, TXBuilt 1975 · S/N TH-691 N6814RBbc414a LLC · Alton Bay, NHBuilt 1981 · S/N 414A0638 N6815TL A Flyers LLC · Monticello, ARBuilt 1981 · S/N 414A0645 N6816BMystic Dreams LLC · Mount Juliet, TNBuilt 1978 · S/N 21062837 N6816SHodges Seth L · Omaha, TXBuilt 1976 · S/N E-810 N6817DGlasscock Charles W Jr · Elm Grove, LABuilt 1981 · S/N 414A0656 N6818XBlue Skys Aero LLC · Vermilion, OHBuilt 1981 · S/N 414A0663 N681RCObsidian Air LLC · Pompano Beach, FLS/N 402C0002 N6821SSouthern States Aircraft LLC · Walland, TNBuilt 1976 · S/N D-9853 N6822EAir Force One LLC · Coral Springs, FLBuilt 1981 · S/N 414A0807 N6822UKw Aircraft LLC · Judson, TXS/N 414A0808 N68233Sunbird Aviation Inc · Bozeman, MTBuilt 1981 · S/N 340A1273 N68236Vaughn Air LLC · Hillsboro, ORBuilt 1981 · S/N 340A1275 N68239Northeast Skywagon LLC · Pittsfield, MEBuilt 1981 · S/N 340A1276 N6823DS A Fliers LLC · Venice, FLBuilt 1980 · S/N 340A1042 N6823FTreetop Aviation LLC · Wilson, NCBuilt 1980 · S/N 340A1043 N68245Registration Pending · Anderson, SCRegistration pendingBuilt 1980 · S/N 340A1204 N6824LEnvironmental Evolutions Transportation Inc · Robstown, TXBuilt 1980 · S/N 340A1201 N6824QBartholomew And Associates Realty Inc II · Edmond, OKBuilt 1964 · S/N D-7447 N6824RSquadron 5 Inc · Saratoga, CABuilt 1966 · S/N T210-0224 N6825TSongbird Aviation LLC · Larkspur, CABuilt 1981 · S/N 340A1208 N6826BDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1978 · S/N 21062840 N6826LThomas Faulhaber Pc · La Veta, COBuilt 1980 · S/N 340A1213 N6826QBeechcraft Heritage Museum · Tullahoma, TNBuilt 1964 · S/N D-7450 N6827LDuke Aviation LLC · Woodridge, ILBuilt 1980 · S/N 340A1219 N6828PSnowfox Insurance Inc · Pace, FLBuilt 1981 · S/N 340A1226 N6828QHenson Jimmy Dean · Maysville, OKBuilt 1964 · S/N D-7595

Back to AD 86-13-04 R3