Registered aircraft · 5,440

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:95-26-15-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1') 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:95-26-15-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1')
  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:95-26-15-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1')
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.

N340TSNighthawk Flight Systems Inc · Vista, CABuilt 1980 · S/N 340A0999 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 N340VCStc Aviation Inc · Saint Cloud, MNS/N 340A0296 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 N340XPN340xp LLC · Wellington, FLS/N 340A0741 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 N341Lurky Ilm LLC · Delco, NCBuilt 1981 · S/N TC-2369 N34131United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28971 N34137United Airlines Inc · Chicago, ILBuilt 1999 · S/N 30229 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 N341DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8134 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 N341NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 380 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 N342DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8159 N342JCAviation Investments Inc · Redondo Beach, CAS/N 340A-030 N342NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 381 N343BRendzio Robert J · Dothan, ALS/N TD-2 N343DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8200 N343NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 387 N343RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N TC-1553 N344AAAbsolutamente LLC · Windsor, CABuilt 1992 · S/N 1186 N344CMCargo Aircraft Management Inc · Wilmington, OHS/N 28745 N344DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8171 N344JSWhitewing Aviation LLC · Tuscola, TXBuilt 1979 · S/N 340A0781 N344KDAtares Funding LLC · Miami Beach, FLBuilt 1992 · S/N 26344

Back to AD 95-26-15 R1