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.

N629LSShook Farms LLC · Milan, MIBuilt 1984 · S/N 51077 N62EHJuliett Tango LLC · Alpine, WYBuilt 1991 · S/N 4191 N62FHelicopters Inc · Linden, NJBuilt 1995 · S/N 4341 N62FMMbm Aviation Consultants Inc · Wilmington, DEBuilt 1980 · S/N 2934 N63446Helicopter Services Of Illinois LLC · Fisher, ILBuilt 1981 · S/N 3439 N635GTSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 906 N63864Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N 4517 N63AEAir Evac Ems Inc · O Fallon, MOS/N 45499 N63SHMaine Helicopters Inc · Whitefield, MEBuilt 1979 · S/N 2640 N6401XCity Of Memphis · Memphis, TNBuilt 1999 · S/N 4522 N641HAHelicopter Applicators Inc · Gettysburg, PABuilt 1991 · S/N 51444 N648CAChem-Air LLC · Shreveport, LABuilt 1982 · S/N 3626 N64FCZma LLC · North Little Rock, ARBuilt 1981 · S/N 45539 N64GKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1995 · S/N 4339 N64JBNc Transportation Inc · Loudon, NHBuilt 1978 · S/N 2437 N64TMLake State Companies LLC · Anchor Point, AKS/N 2513 N6501SInternational Air Services Inc Trustee · Carson City, NVBuilt 1990 · S/N 51395 N651HAHelicopter Applicators Inc · Gettysburg, PABuilt 1986 · S/N 51185 N65231Louisville Metro Government · Louisville, KYBuilt 2001 · S/N 5281 N652BBAgricultural Air Services LLC · Jupiter, FLBuilt 1984 · S/N 3800 N6533UTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51439 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 N6603XAerial Applicators Of Missouri LLC · Jonesboro, ARBuilt 1990 · S/N 51412 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

Back to AD 90-13-01 R1