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.

N75YLinville Manor LLC · Reidsville, NCBuilt 1994 · S/N 4304 N762LCLeon County Sheriffs Office · Tallahassee, FLBuilt 1995 · S/N 4363 N764CLKestrel Enterprises Inc · Sun City, AZS/N 2811 N7650MAnw Investment Group LLC · Denham Springs, LABuilt 1971 · S/N 624 N76544Churchill Scott · Jordan, MNBuilt 2001 · S/N 5273 N76DCAdvanced Trucking LLC · Kalispell, MTBuilt 1980 · S/N 45471 N76MQRidge Helicopter LLC · Wilmington, DEBuilt 1980 · S/N 3111 N76PECarson Secure Transport East LLC · Carson City, NVBuilt 1975 · S/N 1818 N76TLJ L Smith Enterprises LLC · Jackson, KYBuilt 1999 · S/N 4523 N770HPDodson International Parts Inc · Rantoul, KSBuilt 2007 · S/N 4624 N77766Usda Aphis Wildlife Services · Cedar City, UTBuilt 2001 · S/N 5279 N777CPWild Goose Airways Of Plant City LLC · Thonotosassa, FLS/N 3429 N777EMAlaskan Wings LLC · Anchorage, AKBuilt 1983 · S/N 45767 N784FNascar Aviation LLC · Silverado, CABuilt 1978 · S/N 2508 N785CBAdvanced Aerial Services Inc · Bristol, VABuilt 1989 · S/N 4051 N78906King County Sheriffs Office · Seattle, WABuilt 2001 · S/N 5277 N789SJAgricultural Air Services LLC · Jupiter, FLS/N 2078 N78AMBell206 LLC · Anchorage, AKBuilt 1989 · S/N 4060 N78BRMontana Air Tankers LLC · Three Forks, MTBuilt 1988 · S/N 4001 N78MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1981 · S/N 3442 N78NLH&G Farms Inc · Corcoran, CABuilt 1974 · S/N 1561 N790RBRight Brother Aviation LLC · Rome, NYBuilt 1988 · S/N 51248 N7935JAerospace Trust Management LLC Trustee · Wilmington, DES/N 652 N7978KMowata Farms LLC · Mamou, LABuilt 1982 · S/N 45492 N79987Usda Aphis Ws · Cedar City, UTBuilt 2001 · S/N 5278 N79AEAvid Aviation Group Inc · Jupiter, FLBuilt 1980 · S/N 45436 N79LRHeger Scott · Scappoose, ORBuilt 1979 · S/N 45200 N79TMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1991 · S/N 51472 N79TVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 45718 N7DQMinnesota Helicopters Inc · Blaine, MNBuilt 1981 · S/N 45685 N800JBHelicopter Applicators LLC · Pembroke, NHBuilt 1979 · S/N 2832 N801CLAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1979 · S/N 45354 N801JBNewwest LLC · Pembroke, NHBuilt 1979 · S/N 2697 N803JBGuardian Aero LLC · Flora, ILBuilt 1991 · S/N 4172 N804LASouthern Helicopter Inc · O Brien, FLBuilt 1971 · S/N 680 N806LACoastal Helicopters Inc · Panama City, FLBuilt 1973 · S/N 1008 N808HLRegistered aircraftN-number assigned, not yet registeredS/N 51581 N808QPalmer Carroll W · Harper, ORBuilt 1980 · S/N 3029 N812URRotor Concepts LLC · Lakeside, AZS/N 1250 N813RRIndian River County Sheriffs Office · Vero Beach, FLBuilt 2002 · S/N 5284 N81519Bell Textron Inc · Fort Worth, TXBuilt 1998 · S/N 4498 N8159JForming Agrotors Inc · Louisville, MSBuilt 1970 · S/N 512 N818HHHermanns Helicopters LLC · Arlington, WABuilt 1974 · S/N 1543 N818RLDoor To Door Aviation LLC · Wilmington, DEBuilt 1993 · S/N 4273 N81ALOrgis B J · Hallettsville, TXBuilt 1979 · S/N 2782 N81PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1977 · S/N 2315 N820HRoma Air Corp · Belle Glade, FLBuilt 1976 · S/N 2079 N821CAChem-Air LLC · Shreveport, LABuilt 1978 · S/N 2518 N827WAWarner Alan/Whiskey Alpha LLC · Fort Worth, TXBuilt 1995 · S/N 4386 N828HAHelo N828ha LLC · Richmond, VABuilt 1980 · S/N 3183

Back to AD 90-13-01 R1