OpenAirDocs.org
AD 2004-22-13

Registered aircraft · 312

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

N316SPSan Juan Aviation LLC · Wilmington, DEBuilt 1983 · S/N 45768N3173HAlabama Law Enforcement Agency · Montgomery, ALBuilt 1982 · S/N 45714N3176LRiggs Bobby W · Lake Mary, FLBuilt 1983 · S/N 45648N3180LGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 51055N3184PMarks Lloyd · Lafayette, LAS/N 45774N3188PMarks Aviation Group LLC · Lafayette, LABuilt 1983 · S/N 45778N318AEAir Evac Ems Inc · O Fallon, MOBuilt 1985 · S/N 51160N3190PVeturis David · Lake Forest, CABuilt 1983 · S/N 45779N321AHBektor III LLC · Kalispell, MTBuilt 1984 · S/N 51100N327AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51365N32AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45327N333EROrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45203N334AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51326N337AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45383N33PPUnited States Department Of Interior · Boise, IDBuilt 1983 · S/N 51051N33RSFlying H Limited LLC · Mesa, AZBuilt 1992 · S/N 51568N343ALBtak LLC · New Baden, ILBuilt 1990 · S/N 51372N34AETrinkle Aviation LLC · Kingsburg, CABuilt 1979 · S/N 45218N351RLOas2 LLC · Orlando, FLBuilt 1991 · S/N 51431N356LArizona Helicopter Services LLC · Prescott, AZS/N 51378N361ALBillings Flying Service LLC · Billings, MTBuilt 1987 · S/N 51212N362ALMarks Lloyd · Lafayette, LABuilt 1991 · S/N 51471N370DPDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 51569N3777MRotor Co · New Braunfels, TXBuilt 1991 · S/N 51485N377LFHelicopter Parts International Inc · Minden, NVBuilt 1989 · S/N 51281N383SHAspen Helicopters Inc · Oxnard, CABuilt 1983 · S/N 51073N38885Back Nine Aerial LLC · New Berlin, WIBuilt 1981 · S/N 45726N388JCSweetwater Landing LLC · Helena, MTBuilt 1981 · S/N 45568N3893UMonarch Enterprises Inc · Kirkland, WAS/N 51020N3895DMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45590N38960Greystones Aviation Worldwide Inc · Dulles, VAS/N 45536N38QHawkeye Helicopter LLC · Lyndon, KSBuilt 1980 · S/N 45364N38THGlobal Aerials Inc · Pembroke Pines, FLS/N 45653N393SSouthwest Heliservices LLC · Mesa, AZBuilt 1980 · S/N 45494N395AEAir Evac Ems Inc · O Fallon, MOS/N 45551N396RLMorris Equipment LLC · Yuma, AZBuilt 1980 · S/N 45-396N397RLBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45397N39LRHornet LLC · Picayune, MSBuilt 1981 · S/N 45654N3KYCommonwealth Of Kentucky · Frankfort, KYFirst renewal noticeS/N 51113N402TDAir Metro Helicopters Inc · New City, NYBuilt 1990 · S/N 51383N405RLGlobal Aviation Florida LLC · Pompano Beach, FLBuilt 1990 · S/N 51405N406PWBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45446N406WHHeli-Works Flight Services LLC · Deer Lodge, MTBuilt 1991 · S/N 51537N412KKElkhorn Aviation Inc · Baker City, ORS/N 45277N413TVTri Rotor Spray & Chemical · Ulysses, KSBuilt 1981 · S/N 45636N4180FCaswell Farms · Durham, CABuilt 1991 · S/N 51469N419DHAerial Applicators Of Missouri LLC · Qulin, MOBuilt 1984 · S/N 51007N4227EMonarch Enterprises Inc · Kirkland, WABuilt 1981 · S/N 45702N4282ZSayre Stanley · Mantua, OHBuilt 1999 · S/N 51499N429ZACoastal Air Service Inc · Panama City, FLBuilt 1980 · S/N 45375
Back to AD 2004-22-13