Skip to content

Registered aircraft · 855

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-10-11-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:89-10-11-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:89-10-11-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:89-10-11-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:89-10-11-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:89-10-11-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.

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, ALBuilt 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 N67767Usda Aphis Ws · Cedar City, UTBuilt 1995 · S/N 5204 N67777S2 Helicopter Services LLC · Albany, TXBuilt 1995 · S/N 5206 N67784United States Army · Redstone Arsenal, ALS/N 5207 N67804Brown Helicopter Inc · Pensacola, FLBuilt 1995 · S/N 5208 N67814Usda Aphis Ws Atoc · Cedar City, UTBuilt 1995 · S/N 5209 N67817King County Sheriff'S Office · Seattle, WABuilt 1995 · S/N 5210 N67830Louisville Metro Government · Louisville, KYBuilt 1995 · S/N 5211 N67833Realstaff Rocket LLC · Keizer, ORBuilt 1995 · S/N 5212 N67841Kt Auburndale LLC · Panama City Beach, FLBuilt 1995 · S/N 5213 N67872Blair Air Service Inc · Lemoore, CABuilt 1995 · S/N 5217 N67873Mf Choppers LLC · Beeville, TXBuilt 1995 · S/N 5218 N67880King County Sheriffs Office · Seattle, WABuilt 1995 · S/N 5221 N67882Mf Helicopters LLC · Troy, WIBuilt 1995 · S/N 5222 N67907Churchill Scott · Jordan, MNBuilt 1995 · S/N 5223 N67908Usda Aphis Ws · Cedar City, UTBuilt 1995 · S/N 5224 N67915Stovall Eric M · Marathon, TXBuilt 1995 · S/N 5225 N67919Ko Hee · Norwood, NJBuilt 1995 · S/N 5226 N67937Churchill Scott · Jordan, MNBuilt 1995 · S/N 5227 N67939City Of Jackson Tennessee · Jackson, TNBuilt 1995 · S/N 5228 N67950United States Army · Redstone Arsenal, ALBuilt 1995 · S/N 5229 N67952City Of Jackson Tennessee · Jackson, TNBuilt 1995 · S/N 5230 N67960Dakota Air Parts International Inc · Fargo, NDBuilt 1995 · S/N 5232 N67961Brown Helicopter Inc · Pensacola, FLBuilt 1995 · S/N 5233

Back to AD 89-10-11 R1