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.

N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367 N2217TTango LLC · Anchorage, AKBuilt 1968 · S/N 185-1369 N22184Rosene Richard W · Newport, RIBuilt 2000 · S/N 29-0227 N2218MBerry Jeffrey M · Palmetto Bay, FLBuilt 2000 · S/N 30-0050 N2219MDubya Aviation LLC · Broken Arrow, OKBuilt 1998 · S/N E3149 N2219TDls Holdings Inc · Arlington, TXBuilt 1968 · S/N 185-1371 N221AARegistered aircraftBuilt 1977 · S/N 21062293 N221ABFlying Banana LLC · Onsted, MIS/N D-9064 N221AKRegistration Pending · Oakwood, OHRegistration pendingBuilt 1966 · S/N 188-0184 N221AWChapman Lawrence N · Placerville, CAS/N 0758 N221CDJaffee Robert · Victoria, MNBuilt 2001 · S/N 0093 N221DCAmob1 LLC · Baton Rouge, LABuilt 1980 · S/N E-1689 N221DPMckenney Bret K · Billings, MTBuilt 1968 · S/N E-6 N221JEElgee John O · Anchorage, AKBuilt 1973 · S/N U20601990 N221MRGaluk Douglas P · Wisconsin Rapids, WIS/N E-1576 N221NPohl Ronald O · Englewood, COBuilt 1981 · S/N E-1892 N221PPLive Pilot Training LLC · Ankeny, IABuilt 1987 · S/N 46-08064 N221RPPastor Randall J · Granite Bay, CABuilt 2004 · S/N 0878 N221TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508061 N221TLLogan Thomas D · Incline Village, NVBuilt 1964 · S/N D-7652 N221VArea 52 Holdings Inc · Darlington, SCBuilt 2003 · S/N 29-0295 N221WSChaz LLC · Wilmington, DEBuilt 1976 · S/N CE-642 N22202Gifford Gregory L · Naples, FLBuilt 1972 · S/N 21059717 N2220NDushek Matthew S · West Hartford, CTBuilt 2000 · S/N 29-0228 N2220SSb Meridian LLC · Heber, CABuilt 1976 · S/N 21061165 N2221QAviation Sales And Charter LLC · Dover, DEBuilt 1968 · S/N 421A0021 N2221ZFielding David J · Scarborough, MEBuilt 1962 · S/N 1850319 N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730 N2223TC & R Leasing LLC · Fairbanks, AKBuilt 1968 · S/N 185-1375 N2224FE C Nelson Inc · Rio Oso, CABuilt 2000 · S/N 30-0051 N2226LSlyngstad Todd · San Jose, CABuilt 1999 · S/N EA-640 N2226RChampion Crane Service Inc · Des Moines, IABuilt 1968 · S/N T210-0376 N2226SE S P Aviation LLC · Wilmington, DEBuilt 1976 · S/N 21061171 N2228DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 29-0246 N2228KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 29-0269 N2228SHannaford Edward M · Roseville, MIBuilt 1976 · S/N 21061173 N2229FMulligan Aviation LLC · Janesville, WIBuilt 2000 · S/N 29-0235 N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174 N2229XByers Gary F · Wasilla, AKBuilt 1969 · S/N 185-1509 N222ACMti Holdings Inc · Birmingham, ALBuilt 1977 · S/N E-1125 N222ASBenham Properties LLC · Sullivan, INBuilt 1968 · S/N TE-526 N222ATSierra 1 Tech Inc · Blue Jay, CABuilt 1968 · S/N 21059098 N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078 N222BGBeaumont David Matthew · Orcutt, CABuilt 2004 · S/N 1095 N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264 N222CBNiki Hankins Consulting LLC · Colorado Springs, COBuilt 1968 · S/N D-8786 N222CRFriendly Skies Aviation LLC · Wilmington, DEBuilt 1982 · S/N E-2040 N222DKVestal Randy L · Darien, GABuilt 1982 · S/N 25-0721 N222DRGoodknight Gregory W · Nevada City, CABuilt 1967 · S/N D-8604 N222DTClipper Sky LLC · Las Vegas, NVS/N D-10130

Back to AD 86-13-04 R3