Registered aircraft · 18,495

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.

N8264QMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1975 · S/N U20603125 N8265XOzark Management Inc · Columbia, MOBuilt 1993 · S/N E-2804 N8266MCenturion Aviation LLC · Groveland, FLBuilt 1970 · S/N 21059266 N82687Boniek Martin J · Mccarthy, AKS/N U20603424 N8268TN8268t LLC · Phoenix, AZBuilt 1990 · S/N CE-1547 N8269QPaola Brett R · Anchorage, AKBuilt 1978 · S/N 18503638 N8269VN8269v Inc · Lewes, DEBuilt 1993 · S/N E-2796 N826MGOrten Symer Enterprises Inc · East Hampton, NYBuilt 1993 · S/N E2782 N826MTG T Acft Inc · Franklin Square, NYBuilt 1979 · S/N TK-109 N826RSSpence Charles A · Midland, TXBuilt 1971 · S/N D-9272 N826TBonanza H35 LLC · Greensboro, NCBuilt 1973 · S/N D-9518 N8272BAndy-Oxy Co Inc · Asheville, NCBuilt 1990 · S/N TH-1601 N8272TWayne Clinton · Greenfield, INBuilt 1967 · S/N D-8473 N8273QHelmericks Isaac J · Palmer, AKBuilt 1976 · S/N U20603134 N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135 N8275ASigillito Michael A · Vero Beach, FLBuilt 1993 · S/N E-2803 N8275MValiair Limited Company Trustee · Casper, WYBuilt 1970 · S/N 21059275 N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136 N8276RSeland David P · Gulfport, MSFirst renewal noticeBuilt 1972 · S/N 30469 N8277DValiair Lc Trustee · Casper, WYS/N E-2798 N8277GCountry Aero LLC · Darwin, MNBuilt 1973 · S/N 18801281T N8277MBlalock Paul T · Longview, TXBuilt 1970 · S/N 21059277 N8278TRegistered aircraftBuilt 1992 · S/N TH-1672 N827APelican Flyers LLC · Metairie, LABuilt 2002 · S/N 40050 N827CDSwiss Wings Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0169 N827DGAfrica Inland Mission International Inc · Peachtree City, GABuilt 1981 · S/N U206-06286 N827EBEbor Management Inc · Alpharetta, GABuilt 1970 · S/N TH-135 N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541 N827SStamp Jeffrey · Little Rock, ARBuilt 2002 · S/N 0362 N827TWGardner Thomas W · Lincoln, MEBuilt 1973 · S/N 21059836 N827VMoore Plane Fun LLC · Toledo, OHS/N E907 N827WCustom Air Inc · Roe, ARBuilt 1968 · S/N D-8743 N827WFCarlton Paul K Jr · College Station, TXBuilt 2003 · S/N 0667 N8281Q9 North LLC · Parker, COBuilt 1976 · S/N U20603142 N8281RDederick Ethan J · Kent, WABuilt 1972 · S/N 30464 N8281ZSpearfish Aviation Inc · Summerset, SDS/N U20604116 N8282RTorrey Daniel B · Ojai, CABuilt 1972 · S/N 30468 N8283WSwampair LLC · Hillsboro, ORBuilt 1993 · S/N CE-1739 N8284FRullman Laurie J Trustee · Reno, NVBuilt 1993 · S/N CE-1747 N8285LGilbran Properties LLC · Oklahoma City, OKBuilt 1993 · S/N CE-1745 N8285RLatimer Mark A · Vernon, TXBuilt 1972 · S/N 30466 N8286FDaedalus Advisory LLC · Seattle, WAS/N CE-1767 N8286M3 Jc LLC · Phoenix, AZBuilt 1970 · S/N 21059286 N8287MProfessional Metal Services Inc · Albion, NEBuilt 1970 · S/N 21059287 N8287QAdventist World Aviation · Wilson, NCBuilt 1976 · S/N U20603148 N8288GFord Flying Service Inc · Doerun, GABuilt 1973 · S/N 18801287 N8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1970 · S/N 21059288 N8289RSebi Aviation Tt LLC · Austin, TXBuilt 1972 · S/N 30470 N828ABChasen Dreams LLC · Hurricane, WVBuilt 2005 · S/N 1419 N828BPHot Wings Aviation Ltd · Wilmington, DEBuilt 2005 · S/N 29-0399

Back to AD 86-13-04 R3