Skip to content

Registered aircraft · 1,150

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:90-13-01-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:90-13-01-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:90-13-01-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:90-13-01-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:90-13-01-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:90-13-01-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.

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, 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

Back to AD 90-13-01 R1