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.

N7255RZaviation LLC · Fort Smith, ARBuilt 1975 · S/N TH-572 N7255TJmfr Aviation LLC · Dallas, TXBuilt 2007 · S/N E-3755 N72567Hart Patrick D · Woodbridge, VABuilt 1985 · S/N E-2280 N7257NPeterson Winston Roy II · Arbuckle, CABuilt 1976 · S/N U20603588 N7258ESchreher Jeremy A · Richmond, VABuilt 1986 · S/N EA-455 N7258NEuroaviation Inc Trustee · KematenBuilt 2007 · S/N E-3758 N7259RAmburgey Gregory B Trustee · Rawson, OHBuilt 1974 · S/N E-628 N725ADSisson David Brent · Lubbock, TXBuilt 1979 · S/N D-10281 N725APSheets Douglas · Goodyear, AZS/N D-10178 N725HBReel Altitude LLC · Hahira, GABuilt 1996 · S/N TH-1776 N725LKDuluth Aviators LLC · Duluth, MNBuilt 2003 · S/N 0668 N725VPTeam Negrich LLC · Osteen, FLBuilt 1971 · S/N U20601664 N725WFSeverson Denis · Palo Alto, CABuilt 2018 · S/N E-4125 N725YGButtonwillow Land And Cattle Co · Buttonwillow, CABuilt 2008 · S/N E-3842 N7267NSwalling John C · Anchorage, AKBuilt 1976 · S/N U20603594 N7268RRural-Em Consulting Inc · Dallas, TXBuilt 1975 · S/N TE-1027 N7269NAk Air Leasing LLC · Homer, AKBuilt 1976 · S/N U20603595 N726AGTwo Tails LLC · Las Vegas, NVBuilt 1993 · S/N CE-1733 N726BADangerstik Corp · Olympic Valley, CABuilt 1979 · S/N TJ-214 N726BGDusty Bg LLC · Greensboro, NCBuilt 1999 · S/N E-3246 N726EASchneider Scott · New Canaan, CTBuilt 2010 · S/N E-3943 N726HSSpmhrt 206 LLC · East Bernard, TXS/N U20606947 N726LAValiair Lc Trustee · Casper, WYBuilt 1974 · S/N 421B0651 N726PMAlpine View LLC · Williston, NDBuilt 2004 · S/N 0981 N726RTCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 421C0087 N726TJJohnstone Thomas T · Panama City, FLBuilt 1976 · S/N TJ-80 N727United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504371 N7273RHarwood Nathan S · Roanoke, TXS/N E-634 N7274RChastain Phillip L · St Louis, MOBuilt 1975 · S/N D-9721 N7276NDancer Aviation LLC · Delphos, OHBuilt 1976 · S/N U20603597 N7277GHealth Flight Services LLC · Orlando, FLBuilt 2007 · S/N TH-2177 N727BVWheels Up Aviation LLC · Madison, MSS/N E-239 N727CBDwr Aviation Enterprises LLC · Vero Beach, FLBuilt 1979 · S/N D-10313 N727CDN727cd LLC · Clearwater, FLBuilt 2001 · S/N 0021 N727DRRoss Trucking LLC · Goldendale, WAS/N U206-0556 N727FValiair Ltd Co Trustee · Casper, WYBuilt 1981 · S/N P21000727 N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912 N727LHHale John A · Ennis, MTBuilt 1965 · S/N P206-0085 N727LTFoster Jeffrey · Baton Rouge, LABuilt 1980 · S/N TJ-313 N727MPAero Assoicates LLC · Wildwood Crest, NJBuilt 2015 · S/N E-4063 N727MSRedd Aviation LLC · Elk City, OKBuilt 1973 · S/N E-409 N727NEDeeair Ltd · Dayton, OHBuilt 1979 · S/N U20605152 N727NGKarp Michael E · Alameda, CABuilt 1963 · S/N CD-689 N727PLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N CE-425 N727PWSteven Bennett Trustee · Boise, IDBuilt 2004 · S/N 1196 N727SPinnacle Aviation Services LLC · Key Largo, FLS/N 1316 N727VCPd Aircraft Llp · Webster, MNBuilt 1968 · S/N CE-202 N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140 N728United States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606877 N7280RMinus 7 Inc · Durango, COBuilt 1975 · S/N TH-588

Back to AD 86-13-04 R3