Registered aircraft · 18,498

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.

N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948 N1576WPowis Michael P · Oak Grove, MOBuilt 1972 · S/N D-9350 N1577HKing Wayne T · Anchorage, AKBuilt 1977 · S/N 18503310 N1577LKoga Corp Inc · Las Vegas, NVS/N E-825 N1577WDshannon Products Ltdregistered · Buffalo, MNBuilt 1972 · S/N E-333 N1578LBaloian Packing Co Inc · Fresno, CABuilt 1976 · S/N E-826 N1579LEvans Christopher A · Lynden, WABuilt 1976 · S/N D-9863 N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639 N157NNewsome Jeffrey S · Blackwell, OKBuilt 1976 · S/N TJ-52 N157RDedoming Russell C IV · Boylston, MABuilt 1991 · S/N CE-1636 N157SGRichland Aviation Inc · Sidney, MTBuilt 1973 · S/N 340-0154 N157TXHlebichuk David D · Montgomery, TXBuilt 2005 · S/N 1669 N157VRoco Air LLC · San Antonio, TXBuilt 2005 · S/N 1472 N1581GKovach Kenneth R · Jefferson, OHBuilt 1979 · S/N 310R1593 N1582QWhite William Wayne · Corona, CABuilt 1977 · S/N 18503485 N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353 N1587UGrant Aviation Inc · Anchorage, AKS/N 20700187 N1588Indianhead Aviation LLC · Polk City, IABuilt 1978 · S/N E-1290 N1588MAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1970 · S/N 18800688 N1589LCain James W · Big Rapids, MIS/N D-9866 N158BBStubbs J Phillip · Richmond, VABuilt 1975 · S/N TH-592 N158BDJ L Aviation LLC · Jonesboro, ARBuilt 1979 · S/N TH-1045 N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540 N158BJPerfectus Inc · Wilmington, DES/N TH-324 N158BMChorman Spraying LLC · Milton, DEBuilt 1981 · S/N TH-1244 N158DGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2016 · S/N TH-2460 N158KPelican Aviation Inc · Gainesville, GABuilt 1980 · S/N TH-1178 N158KSBowerman Marvin · Montgomery, TXBuilt 1982 · S/N TJ-419 N158LFPro Tech Track & Tennis Management Lp · Bullard, TXBuilt 2014 · S/N TH-2425 N158MRT-Bird LLC · Byron Center, MIBuilt 2011 · S/N TH-2312 N158MST Hiers LLC · Barney, GABuilt 2017 · S/N TH-2492 N158NRoss Adam · Texarkana, TXBuilt 1981 · S/N EA-197 N158NCIal Corp · Lewes, DEBuilt 1974 · S/N TH-444 N158PCSewalt Steve · Victoria, TXBuilt 2018 · S/N TH-2500 N158RFBeech Bound LLC · Morgantown, WVBuilt 1978 · S/N TH-941 N158RMWings Lc · Baltimore, MDBuilt 1988 · S/N TH-1543 N158RSRegistration Pending · Wallace, CARegistration pendingBuilt 1981 · S/N TJ-359 N158RWHeartfield J Thad · Beaumont, TXBuilt 2008 · S/N TH-2221 N158RXMurkowski Francis M · Anchorage, AKBuilt 1979 · S/N 18503784 N158SWFern Leasing Corp · Larkspur, CABuilt 1999 · S/N TH-1921 N158TBLunt Christopher K · Marco Island, FLBuilt 1977 · S/N TH-826 N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68 N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008 N158YBCommercial Bank Aviation LLC · Harrogate, TNBuilt 2014 · S/N TH-2410 N1591WMuraszko Raymond P · Monroe, NJBuilt 1972 · S/N CE-381 N1592FReynolds Frederick A · Pilot Point, AKBuilt 1966 · S/N 185-0974 N1592GCtl Legacy Holdings LLC · Midland, TXBuilt 1974 · S/N 421B0822 N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832 N1592WDebonair Flying Club Inc · Medon, TNBuilt 1972 · S/N CE-383 N1593LBurr Walter E · Tecumseh, MIBuilt 1976 · S/N CE-637

Back to AD 86-13-04 R3