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.

N9613ZAlosanel Charter Inc · Concord, NHFirst renewal noticeS/N U20606575 N9614KPassmore Stephen B · Lacrosse, WABuilt 1983 · S/N T18803962T N9617ZWright William F Trustee · Anchorage, AKS/N U20606578 N9618HRegistration Pending · Wasilla, AKRegistration pendingBuilt 1977 · S/N 18503454 N961RCWalker Kenneth L · Hornbeak, TNS/N E-4048 N961SFBdr Aviation LLC · Ponte Vedra Beach, FLBuilt 1964 · S/N D 7541 N961TTLupia Raul H · Raleigh, NCBuilt 2004 · S/N 42054 N961WWMeacham Electric Inc · Marathon, FLBuilt 1970 · S/N CE316 N9620GMehling Robert C · Hardin, MTS/N 18801564 N9620QObar Danny · Middleton, IDBuilt 1979 · S/N 18503780 N9623GBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802596T N9623RUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606906 N9624MWater Solutions Inc · Half Moon Bay, CABuilt 1995 · S/N 29-0037 N9626GFly 2 Crp LLC · Cleveland, TXBuilt 1972 · S/N U20601826 N9629GSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 18801570 N962PWHamilton Jesse L · Aledo, TXBuilt 2004 · S/N 1125 N962RGBoucher John C · Lakeside, AZBuilt 1967 · S/N U206-0957 N9632ERoberts Terrell N III · Kensington, MDBuilt 1976 · S/N 76-30814 N9632ZAngelone Inc · Elkhart, INS/N U20606585 N96335Cysewski Roxanne Trustee · Rllng Hls Est, CABuilt 1983 · S/N EA-400 N9635CAirmans Aviation Co Ltd · Fort Smith, ARBuilt 1983 · S/N T30300196 N9636YCarranza Chris J · Stanfield, AZBuilt 1981 · S/N 21064566 N963CDBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 1470 N963DBCommonwealth Aircraft Inc · Ashland, VABuilt 2005 · S/N 1575 N963RTAppalachian Foothills Contracting Inc · Lexington, KYBuilt 2004 · S/N 1169 N963SGElephant Shoe Air LLC · Vienna, VABuilt 1984 · S/N TJ-452 N9641ZWhitehead Michelle W · Centralia, WABuilt 1982 · S/N U20606592 N9643ZAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1982 · S/N U20606594 N9644GKatmai Air LLC · Anchorage, AKS/N U20601844 N9649EN9649e LLC · Alexander, ARBuilt 1978 · S/N 78-30902 N9649GAllen Todd N · Mccall, IDBuilt 1977 · S/N U20603819 N964DCorporate Consulting Service Instruments Inc · Akron, OHBuilt 1981 · S/N TE-1190 N964HBHubbard Aviators LLC · Harrison, ARBuilt 1964 · S/N D-7629 N964PBonanza 964 LLC · Davie, FLBuilt 1976 · S/N E-800 N964SBlankenship Shawn W · Theodosia, MOBuilt 1964 · S/N D-7493 N9651MGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700715 N9652EKoschara Nathaniel · Geneseo, NYBuilt 1977 · S/N 78-30863 N9653ESpruce Goose Aircraft LLC · Blaine, MNS/N 76-30834 N9655GMiddle Fork Aviation Inc · Challis, IDBuilt 1972 · S/N U20601855 N965CSSynnestvedt Cory J Trustee · Napa, CABuilt 2024 · S/N E-4157 N965GHHancock Aircraft Sales LLC · Baton Rouge, LAS/N 1666 N9664KUsda Aphis Ppq · Edinburg, TXBuilt 1983 · S/N 18803965T N966DEHubbard Richard O · Fort Worth, TXBuilt 1981 · S/N E-1865 N966MPPerone Michael S · Fort Pierce, FLBuilt 2023 · S/N XRG-720 N966MTInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N P21000584 N966SKCodorniz Aviation LLC · Houston, TXBuilt 2005 · S/N E-3647 N966UBTex Ark Air Corp · Melissa, TXBuilt 1977 · S/N TJ-120 N96734D & G Aviation LLC · Woodward, OKBuilt 1976 · S/N 21061213 N9673ELeedy Donald W · West Chester, OHBuilt 1976 · S/N 76-30823 N9674GN1705r Inc · Cobb, CAS/N U20601874

Back to AD 86-13-04 R3