OpenAirDocs.org
AD 86-13-04 R3

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
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.

N1819LBlack Kettle Inn LLC · Cabool, MOS/N E-838N1819MDjb Asset Management LLC · Oakdale, CABuilt 1981 · S/N EA-245N181ACTwo Tall Tamaracks LLC · Ovando, MTBuilt 1980 · S/N CE-914N181CBBuchanan Clayton W · Fernandina Beach, FLBuilt 1970 · S/N D-9124N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220N181JPRegistered aircraftS/N CE-965N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363N181KTRegistered aircraftBuilt 2000 · S/N 30-0056N181PJPeake Herschel S · Dallas, TXBuilt 1976 · S/N D-9876N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408N181WTMeadows Robert K · Macon, GABuilt 2003 · S/N 0638N1820FHamilton Aviation LLC · Waycross, GABuilt 1981 · S/N E-1893N1820LSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-843N1820RBarkhimer James C · Iraan, TXBuilt 1974 · S/N 18502535N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581N1821FAlexander Travis · Hudson Oaks, TXS/N 21058721N1821RHoward Todd R · Minneapolis, MNBuilt 1974 · S/N 18502536N1822NMars Michael Morrow · Collierville, TNBuilt 1981 · S/N D-10377N1822ROney Tony K · Anchorage, AKBuilt 1974 · S/N 18502537N1822WLawrence Kevin M · Meridian, MSBuilt 1973 · S/N D-9424N1823RJones Alfred J · Friendsville, PABuilt 1974 · S/N 18502538N18246Radial-Air Leasing Inc · Caro, MIBuilt 1977 · S/N CE-720N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877N1825QCree William H III · Long Beach, CABuilt 1977 · S/N 18503492N1825RKincaid James B · Wasilla, AKBuilt 1974 · S/N 18502540N1825SEngebretson Christopher D · Greenville, INS/N E-1898N1826LRhr Management Inc · Bancroft, WIBuilt 1976 · S/N E-845N1826VBig Blue Sky Aero LLC · Austin, TXBuilt 1997 · S/N E-3086N18271Ramsey Richard K · Houston, TXBuilt 1977 · S/N E-1068N18275Strong Tower Worship Center LLC · Delhi, LAS/N E-1071N1827LCone James R Jr · Lubbock, TXS/N TH-741N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N18284Condor Aviation LLC · Bethlehem, PABuilt 1977 · S/N E-1073N18287Three Wings Aviation LLC · Kalispell, MTBuilt 1977 · S/N D-10032N1828FDrew Kevin · Fredonia, PABuilt 1965 · S/N 21058728N18290Koelbel Scott W · Spring, TXBuilt 1977 · S/N E-1076N18291Meoli Christopher J · Rancho Mirage, CABuilt 1977 · S/N CE-724N18294Bundy Holdings LLC · Walnut Grove, MOBuilt 1977 · S/N D-10034N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282N1829WRight Wing LLC · Newnan, GABuilt 1973 · S/N E-387N182HLBelles Flyers Inc · Wilmington, OHBuilt 1973 · S/N 18261843N182SZHigh Wing Aviation LLC · Phoenix, AZBuilt 1974 · S/N 18263278N18302Allison Aircraft Sales LLC · Avon, CTBuilt 1977 · S/N E-1081N18304Bean David Jay · Miami, TXBuilt 1977 · S/N D-10037N18307Wings Management LLC · Springville, UTBuilt 1977 · S/N D-10038N18308Jlmc Blackland LLC · Marietta, GABuilt 1977 · S/N E-1083N1830FKing Barry J · Bentonville, ARBuilt 1981 · S/N E-1905N1830SN1830s Aviation LLC · Gainesville, GABuilt 1981 · S/N E-1906
Back to AD 86-13-04 R3