Skip to content

AD 89-22-01 R1 L

Registered aircraft · 1,179

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

N67001Usda Aphis Ws Atoc · Cedar City, UTBuilt 1993 · S/N 5101 N67041Desoto County Sheriff Dept · Hernando, MSBuilt 1993 · S/N 5104 N67053West Hills Aviation Inc · Huron, CABuilt 1993 · S/N 5105 N67099Spartanburg County Sheriffs Office · Spartanburg, SCBuilt 1993 · S/N 5108 N67110Mf Helicopters LLC · East Troy, WIBuilt 1993 · S/N 5109 N67113West Hills Aviation Inc · Huron, CABuilt 1993 · S/N 5111 N67130Mf Helicopters LLC · East Troy, WIBuilt 1993 · S/N 5113 N67147Usda Aphis Wildlife Services · Cedar City, UTBuilt 1993 · S/N 5115 N67172Veturis David · Lake Forest, CABuilt 1993 · S/N 5118 N67176Kootenai County Regional Air Support · Hayden, IDBuilt 1994 · S/N 5119 N67183State Of Louisiana · Baton Rouge, LABuilt 1993 · S/N 5120 N67231United States Army · Ft Rucker, ALFirst renewal noticeBuilt 1993 · S/N 5124 N67234Brown Helicopter Inc · Pensacola, FLBuilt 1993 · S/N 5125 N67235Brown Helicopter Inc · Pensacola, FLBuilt 1993 · S/N 5126 N67265Usda Aphis Ws · Cedar City, UTBuilt 1993 · S/N 5130 N67269Usda Aphis Ws · Cedar City, UTBuilt 1994 · S/N 5132 N67273Brown Helicopter Inc · Pensacola, FLBuilt 1994 · S/N 5133 N67301Mf Helicopters LLC · East Troy, WIBuilt 1994 · S/N 5135 N67323Coastal Helicopters Inc · Panama City, FLBuilt 1993 · S/N 5136 N67328Realstaff Rocket LLC · Salem, ORS/N 5137 N67347Usda Aphis Ws Atoc · Cedar City, UTBuilt 1994 · S/N 5142 N67363Georgia State Patrol Aviation Division · Kennesaw, GAS/N 5145 N67374Blair Air Service Inc · Lemoore, CABuilt 1994 · S/N 5146 N67411Coastal Helicopters Inc · Panama City, FLS/N 5148 N67428United States Army · Redstone Arsenal, ALBuilt 1994 · S/N 5149 N67432Brown Helicopter Inc · Pensacola, FLBuilt 1994 · S/N 5151 N67442Anatasia Mosquito Control District · Saint Augustine, FLBuilt 1994 · S/N 5152 N67455Brown Helicopter Inc · Pensacola, FLBuilt 1994 · S/N 5154 N67457Johnson Timothy D · Bluff City, TNBuilt 1994 · S/N 5155 N67516Coastal Helicopters Inc · Panama City, FLBuilt 1994 · S/N 5164 N67525Usda Aphis Wildlife Services · Cedar City, UTBuilt 1994 · S/N 5166 N67534Sholton Birgitte · Wasilla, AKBuilt 1994 · S/N 5167 N67561Brown Helicopter Inc · Pensacola, FLS/N 5169 N67569Anastasia Mosquito Control District · Saint Augustine, FLBuilt 1994 · S/N 5171 N67572Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1994 · S/N 5172 N67578Coastal Helicopters Inc · Panama City, FLBuilt 1994 · S/N 5173 N67580United States Army · Fort Rucker, ALFirst renewal noticeBuilt 1994 · S/N 5174 N67599Southmark Aviation Inc · Hattiesburg, MSBuilt 1994 · S/N 5175 N67606Robinson Air Crane Inc · Miami, FLBuilt 1994 · S/N 5177 N67609Peacocke John P · Tomball, TXS/N 5178 N67622Brown Helicopter Inc · Pensacola, FLBuilt 1994 · S/N 5180 N67656Lenox Oil Inc · Lenox, MIBuilt 1994 · S/N 5184 N67662Austin Police Department · Pflugerville, TXBuilt 1994 · S/N 5186 N67669United States Army · Redstone Arsenal, ALBuilt 1994 · S/N 5189 N67670Usda Aphis Wildlife Services · Cedar City, UTBuilt 1994 · S/N 5190 N6768XJl Aviation Inc · Boring, ORBuilt 1987 · S/N 3966 N67715Georgia State Patrol Aviation Div · Kennesaw, GABuilt 1995 · S/N 5194 N67744Hendrickson Flying Service Inc · Rochelle, ILBuilt 1995 · S/N 5199 N67745Brown Helicopter Inc · Pensacola, FLBuilt 1995 · S/N 5200 N67761Whittington Kinion · Durant, OKBuilt 1995 · S/N 5203

Back to AD 89-22-01 R1 L