Skip to content

Registered aircraft · 1,016

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:81-18-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:81-18-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:81-18-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:81-18-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:81-18-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:81-18-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.

N64TMLake State Companies LLC · Anchor Point, AKS/N 2513 N65231Louisville Metro Government · Louisville, KYBuilt 2001 · S/N 5281 N652BBAgricultural Air Services LLC · Jupiter, FLBuilt 1984 · S/N 3800 N6566ABrowns Aviation LLC · East Hampton, CTBuilt 1973 · S/N 1204 N656TLTopside Aviation Inc · Brasstown, NCBuilt 1971 · S/N 656 N657CCClear Creek Construction LLC · Lysite, WYBuilt 1977 · S/N 2295 N65ALHq Rentals Ltd · Dover, OHS/N 1443 N66013Blackbird Aero LLC · Boca Raton, FLBuilt 2002 · S/N 5283 N660HAHelicopter Applicators Inc · Gettysburg, PABuilt 1979 · S/N 45219 N6651HR & R Conner Aviation LLC · Conner, MTBuilt 1979 · S/N 45211 N66RRRiggs Rock Alan · Lake Mary, FLBuilt 1979 · S/N 45278 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, ALBuilt 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, ALBuilt 1994 · S/N 5174 N67599Southmark Aviation Inc · Hattiesburg, MSBuilt 1994 · S/N 5175 N67606Robinson Air Crane Inc · Miami, FLBuilt 1994 · S/N 5177

Back to AD 81-18-01 R1