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.

N2824MDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 1144 N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025 N282CDAurora Partners LLC · Oregon City, ORBuilt 2004 · S/N 1136 N282EEFogprop N282ee LLC · Bolinas, CABuilt 2005 · S/N 1619 N282JLSieck Joshua · Edmond, OKBuilt 1967 · S/N TE-355 N282PHMission Padamo Aviation And Support Inc · Luray, VABuilt 1980 · S/N U20606068 N282RTenere Ventures LLC · Wilmington, DEBuilt 1981 · S/N CE-951 N2830AMarathon Heater Inc · Del Rio, TXBuilt 1970 · S/N E-201 N2836DSale Reported · Yucaipa, CASale reportedBuilt 1966 · S/N 411-0190 N2838WFreebird LLC · Leawood, KSBuilt 1973 · S/N CE-446 N283DFrohbieter Alan · Superior, COBuilt 1979 · S/N TK-112 N283MAAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1975 · S/N TH-669 N283RDBengtson Douglas Richard · Woodinville, WABuilt 1981 · S/N 21064320 N283TBNance Joseph W · Fort Collins, COBuilt 1977 · S/N U20603956 N283TMSpady Jeffrey · Springfield, ORBuilt 1998 · S/N E-3185 N2842WHeisey Ronald B · Friendswood, TXBuilt 1973 · S/N D-9491 N2843WJ & L Equipment Sales & Rental LLC · Andersonville, TNBuilt 1973 · S/N D-9496 N2844DMichigan Aeronautics Commission · Lansing, MIBuilt 1994 · S/N TH-1726 N2846WJohnson Daniel P · Williamsburg, IABuilt 1973 · S/N D-9497 N28487Jcb Enterprise LLC · Wilmington, DEBuilt 2000 · S/N LIV-209 N2848WBlack Brian K · Gillette, WYBuilt 1973 · S/N D-9492 N284CDOld Hickory Flyers · Franklin, TNBuilt 2005 · S/N 1294 N284DReeves Stephen Trustee · Brawley, CABuilt 1978 · S/N E-1303 N284DMDreamworks Aviation LLC · Palm Beach Gardens, FLBuilt 1984 · S/N 421C1406 N284JAChapman Adrian P · West Chester, PABuilt 2025 · S/N E-4163 N284JWOrdway Jepson · Freeville, NYBuilt 1973 · S/N D-9495 N284KBRoper Lawrence F Jr · Georgetown, SCS/N 40068 N284LMB-Airborne LLC · Woodbine, MDBuilt 2005 · S/N 1284 N284SVQuality Feed Grains · Harrison, ARBuilt 1999 · S/N 99-301028 N2852WButcher Charles · Germantown, TNBuilt 1973 · S/N TH-349 N2854PHakari Wesley Jon · Sioux Falls, SDBuilt 1979 · S/N CE-858 N2856QFoster Aaron J · Missoula, MTBuilt 1975 · S/N U20603005 N2858WHought Lowell T · Olathe, KSBuilt 1973 · S/N TE-927 N2859WKoonce J Michael · Berkeley, CABuilt 1973 · S/N E-446 N285HGeorge Gary D · Humble, TXBuilt 1977 · S/N CE-758 N285HABlacqjacq Aviation Co · Wilmington, DEBuilt 1975 · S/N TH623 N285HPGaines Robert M · Nashville, TNBuilt 1949 · S/N NAV-4-1968 N285NTotem Air Inc · Seattle, WABuilt 1968 · S/N 421-0169 N285TCSickinger Alan W · New Philadelphia, OHBuilt 1947 · S/N NAV-4-473 N285WAN285wa LLC · Carthage, NCS/N D-7889 N2861WAustin And Austin Inc · Stafford, KSBuilt 1973 · S/N E-448 N2862WBonanza 62w LLC · Richmond, INBuilt 1973 · S/N D-9504 N2863WWarrick Motors LLC · Newton, IABuilt 1973 · S/N CE-451 N286AKDog Island Air Inc · Wilmington, DEBuilt 2002 · S/N 0303 N286CMB&K Aircraft Leasing LLC · West Plains, MOBuilt 1986 · S/N 46-8608043 N286TCJb Aviation LLC · Waxahachie, TXBuilt 1986 · S/N 21065001 N286WSchlutz Greg F · Longmont, COBuilt 1966 · S/N D-8042 N2870WRobinson John D · Peachtree City, GABuilt 1973 · S/N D-9501 N2871WBuess Wayne R · Shirley, NYBuilt 1974 · S/N TH-462 N2872KR N Geraci LLC · Lutz, FLBuilt 1979 · S/N 18053108

Back to AD 86-13-04 R3