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.

N340TTPrecision Aviation LLC · Costa Mesa, CABuilt 1980 · S/N 340A1034 N340UGonzalez Pablo II · Sweeny, TXBuilt 1978 · S/N 340A0530 N340UMSouthwest Management Group Inc · Farmington, NMBuilt 1979 · S/N 340A0698 N340VAMel Hambelton Ford Inc · Wichita, KSBuilt 1979 · S/N 340A0915 N340VLVanguard R&R Lease Co Inc · Dallas, TXBuilt 1984 · S/N 340A1811 N340VVYouth Aviation Academy · Roseville, CABuilt 1972 · S/N 340-0087 N340WPraetorian Aviation Services LLC · Alva, FLBuilt 1973 · S/N 340-0317 N340WAFoshay Laird · Paso Robles, CABuilt 1972 · S/N 340-0035 N340WDKnoxville Air Charter Service LLC · Strawberry Plains, TNBuilt 1974 · S/N 340-0509 N340WGBartlein & Co Inc · Santa Barbara, CABuilt 1972 · S/N 340-0182 N340WHN340dg LLC · Spanish Fork, UTBuilt 1974 · S/N 340-0366 N340WJIntegritas Aviation LLC · Cedar Park, TXBuilt 1979 · S/N 340A0774 N340WMHarco Aviation LLC · Houston, TXBuilt 1978 · S/N 340A0612 N340WPNnk Holdings LLC · San Antonio, TXBuilt 1981 · S/N 340A1240 N340XCPrairie Aero LLC · Baldwin City, KSBuilt 1976 · S/N 340A0098 N340XXTaylor Christopher A · Phoenix, AZBuilt 1979 · S/N 340A0689 N340YDown The Line LLC · Newport Beach, CAS/N 340A-0404 N340YCBa Air LLC · Searcy, ARBuilt 1977 · S/N 340A0375 N340YPSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A-0990 N340YZN340yz Corp Trustee · Wilmington, DEBuilt 1976 · S/N 340A0019 N3412QPoulsen Melvin J · Orem, UTS/N 320E0012 N3417GDemark Aviation Inc · Wilmington, DEBuilt 1976 · S/N 310R0825 N3417QGholami Amir H · Santa Rosa, CABuilt 1966 · S/N 320E0017 N3418GOppermann William A · Derby, KSBuilt 1976 · S/N 310R0826 N3419JBlackhawk Air LLC · La Porte City, IABuilt 1980 · S/N T18803639T N341ATKlodd Stephen · Granbury, TXBuilt 1978 · S/N 340A0422 N341BCAbeflies LLC · Montvale, NJBuilt 1972 · S/N 340-0015 N341BGAttack Jack Enterprises LLC · Wilmington, DEBuilt 1973 · S/N 340-0233 N341CMBc Aviation · Perham, MNBuilt 1981 · S/N 340A1255 N341HCStc Aviation Inc · Saint Cloud, MNBuilt 1979 · S/N 340A0798 N341JPRed Arrow Leasing Inc · Paw Paw, MIS/N 340A0293 N341MTI2i Logistics LLC · Wheeling, ILBuilt 1980 · S/N 340A0980 N341PSWestern States Air LLC · Phoenix, AZS/N 29-0341 N341SCShedd Aviation LLC · Columbus, INBuilt 1984 · S/N 340A1810 N341SJAga Aviation LLC · Lewes, DES/N 340A0222 N341TVWild Hare Enterprises LLC · Valparaiso, INBuilt 1981 · S/N 340A1277 N341UMedic Choppers LLC · Springdale, ARS/N TE-826 N341VTBelmont Leasing LLC · Gig Harbor, WABuilt 1964 · S/N D-7589 N3422Hergenrather Michael · Spring, TXS/N U20602920 N3422LAwsm Inc · Grand Canyon, AZBuilt 1967 · S/N U206-0722 N3425PCw Designer Homes Inc · Burnet, TXBuilt 2001 · S/N E-3425 N3426LCurtis Jeremy A · Fairbanks, AKBuilt 1966 · S/N U206-0726 N342EAAfrican Inland Mission International · Peachtree City, GAS/N U20606197 N342FDCarver Mark D · Alma, GABuilt 1966 · S/N CE-101 N342RCHyland'S Pharmacy LLC · Wheeler, TXBuilt 1982 · S/N 421C-1243 N342SHorn Travis L · Clarksville, ARBuilt 1969 · S/N E-189 N342TTLewis Charles Ryan · Napa, CABuilt 2004 · S/N 1236 N342UWelch Robert T · Alamogordo, NMBuilt 1971 · S/N D-9251 N3431LJacobs Brittany Lyn · Seattle, WABuilt 1966 · S/N U206-0731 N3432FBierschwale Land Co LLC · Mason, TXBuilt 1977 · S/N 21062407

Back to AD 86-13-04 R3