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.

N171VTShly Aviation LLC · Carnegie, PABuilt 2002 · S/N 0142 N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742 N1721Qualitair LLC Trustee · MichelstadtBuilt 1993 · S/N E-2783 N1723BBoyko George · Tarpon Springs, FLBuilt 1979 · S/N 206-05190 N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360 N1725WEdwards John G · Stoneville, NCS/N D-9400 N1726RPetumenos Timothy J · Anchorage, AKBuilt 1974 · S/N 18502447 N1728RIcenogle Roger A · Inver Grove, MNBuilt 1974 · S/N 18502449 N172DHSanta Lucia 930 LLC · Greenwich, CTBuilt 2014 · S/N TH-2403 N1730ATapley Brian K · Dothan, ALBuilt 1988 · S/N 89-301004 N1731WCollins Air LLC · Kennett, MOBuilt 1972 · S/N E-369 N1733RNorthstar Holdings LLC · Anchorage, AKBuilt 1973 · S/N U20602068 N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735 N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755 N1735ERsc Ventures LLC · Phoenix, AZBuilt 1978 · S/N 310R1555 N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403 N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405 N1737EKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1556 N173KHD & B Management LLC · Clayton, GABuilt 2004 · S/N 1191 N173KTCrawford Chris M · North Dinwiddie, VAS/N 40035 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N173QLively Scott Jacob Charles · Greenbrier, ARBuilt 1964 · S/N D-7350 N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259 N1740WCarlsbad Raceway Corp · Hemet, CABuilt 1972 · S/N CD-1302 N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1743RChronicle Aerospace Inc · Wilmington, DEBuilt 1974 · S/N 18502463 N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404 N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765 N1745RFiske James K · North Andover, MAFirst renewal noticeBuilt 1974 · S/N 18502465 N1745WThoroughscape Inc · Wellington, FLBuilt 1972 · S/N CE-409 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1748RNorthstar Holdings LLC · Anchorage, AKBuilt 1980 · S/N U20605438 N1748UIliamna Air Taxi Inc · Iliamna, AKBuilt 1976 · S/N 20700348 N1748WBas Part Sales LLC · Greeley, COBuilt 1972 · S/N TE-887 N1749UFreshwater Adventures Inc · Dillingham, AKBuilt 1976 · S/N 20700349 N174DSSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 414A0216 N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174 N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73 N17509Starke Charles H III · Weirsdale, FLBuilt 1976 · S/N E-972 N1750RShort James B · Anchorage, AKBuilt 1974 · S/N 18502470 N1750URenfro Michael W · Bethel, AKBuilt 1976 · S/N 20700350 N1750WYounger Benjamin · Narrowsburg, NYBuilt 1972 · S/N D-9406 N17520Patterson William · Spring, TXBuilt 1976 · S/N E-974 N1752WMichael S Austin Dmd Ms Psc · Utica, KYBuilt 1972 · S/N E-373 N1753WConservative Three LLC · Taft, CABuilt 1972 · S/N CE-410 N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354 N1754XWest Alabama Lime Co Inc · Livingston, ALBuilt 1975 · S/N 21060775 N1755WAis Construction Equip Corp · Grand Rapids, MIBuilt 1972 · S/N E-374 N17561Demott Andrew Dolphus III · Hernando, FLBuilt 1977 · S/N D-9983

Back to AD 86-13-04 R3