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.

N828WPBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 45294 N83149Sky Air Center Unlimited LLC · Burleson, TXBuilt 1973 · S/N 1045 N83193R&B Helicopters Inc · Salinas, CABuilt 1973 · S/N 943 N831RLOrgis B J · Hallettsville, TXBuilt 1979 · S/N 2728 N833AMBryant William D · Woodlawn, VABuilt 1968 · S/N 189 N837YMHeli Mart Inc · Costa Mesa, CAS/N 2530 N83AEAir Evac Ems Inc · O Fallon, MOS/N 45272 N83APL&R Investment Partners LLC · Wilmington, DES/N 4439 N83CKGeorgia Equipment And Suplus Inc · Peachtree City, GAS/N 1463 N83TJGotcher Corby W · West Columbia, TXBuilt 1982 · S/N 3594 N841YTTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 1796 N84CKCroman Corp · White City, ORBuilt 1977 · S/N 2253 N852SSAg Air Inc · Johnstown, COS/N 51270 N853SSTippmann Choppers LLC · Fort Wayne, INBuilt 1980 · S/N 45584 N85AWScotts Helicopter Service · Le Sueur, MNS/N 45261 N85CAChurchill Scott · Le Sueur, MNBuilt 1967 · S/N 101 N85RBScott John D · Lyndon, KSBuilt 1972 · S/N 831 N860DPNewton Property Leasing LLC · Greene, IABuilt 1975 · S/N 1716 N862MChorman Spraying LLC · Milton, DEBuilt 1997 · S/N 4473 N866ELEly Ag Services LLC · Sallisaw, OKBuilt 1980 · S/N 3036 N866HLake Superior Helicopters LLC · Duluth, MNBuilt 1981 · S/N 3291 N866MMiddlesex County Mosquito Extermination Commission · Edison, NJBuilt 1998 · S/N 4476 N867CHNorthview Christian Church · Dothan, ALBuilt 1974 · S/N 1371 N868HWeyerhaeuser Nr Co · Seattle, WABuilt 1989 · S/N 51318 N868JBHorizon Helicopter LLC · Pembroke, NHBuilt 2000 · S/N 4534 N868KKCoastal Helicopters Inc · Panama City, FLBuilt 1976 · S/N 2031 N86DXTopside Aviation Inc · Brasstown, NCBuilt 1986 · S/N 3960 N86FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1976 · S/N 2104 N86NCb Couch Inc · Walcott, ARBuilt 1980 · S/N 3204 N86PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1991 · S/N 51436 N874MAnastasia Mosquito Control District · Saint Augustine, FLBuilt 2003 · S/N 4569 N885MCPolk County · Bartow, FLBuilt 2005 · S/N 4592 N887EHVertical Vegetation Management LLC · Darlington, INBuilt 1975 · S/N 1774 N88HCTri-Rotor Spray & Chemical · Ulysses, KSBuilt 1975 · S/N 1576 N88PPGo Heli LLC · San Diego, CABuilt 1980 · S/N 3215 N88TANorthwest Helicopters I Inc · Olympia, WABuilt 1980 · S/N 2990 N88TCHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2220 N890RPAmerican Ag Aviation Inc · Five Points, CABuilt 1982 · S/N 3602 N890SPWest Virginia State Police · South Charleston, WVBuilt 2001 · S/N 5269 N894HAHelo N894ha LLC · Richmond, VAS/N 3278 N895SCAerospace Trust Management LLC Trustee · Wilmington, DES/N 1611 N895SPWest Virginia State Police · South Charleston, WVBuilt 1995 · S/N 5220 N899BHNisource Corporate Services Co · Gary, INFirst renewal noticeS/N 51089 N89AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45433 N89APBlue Dasher Aviation LLC · Glastonbury, CTBuilt 1973 · S/N 975 N89PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1975 · S/N 1751 N89SSAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 1010 N89TTBrunskill Stephen D · Lodi, CABuilt 1975 · S/N 1857 N8AUDodson International Parts Inc · Rantoul, KSBuilt 1990 · S/N 4089 N8BQBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 51108

Back to AD 90-13-01 R1