Registered aircraft · 614

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-26-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-26-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-26-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-26-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-26-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-26-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.

N369SCVertical Flight Path LLC · Wilmington, DES/N 380273D N369SDPyramid Property Development And Management LLC · Cedar Lake, INBuilt 2000 · S/N 0548E N369TAHva Inc · Summersville, WVBuilt 1996 · S/N 0529E N369TRChehalem Helicopters LLC · Newberg, ORBuilt 1977 · S/N 570141D N369TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2017 · S/N 0269FF N369WYReece Construction Company · Marysville, WABuilt 1981 · S/N 510976D N369ZMHelios Helicopters LLC · Clackamas, ORS/N 1000259S N36FGCalifornia Department Of Fish & Wildlife · Sacramento, CABuilt 2020 · S/N 0322FF N36KRDragonfly Aviation LLC · Mirando City, TXBuilt 1978 · S/N 580315D N371PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0345FF N3766ZBanfield Patrick C · Frazier Park, CABuilt 1974 · S/N 440588S N377LWPremier Helicopters LLC · Kalispell, MTS/N 0523E N383FJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1990 · S/N 0440E N387RFMid America Flight Museum · Mount Pleasant, TXBuilt 1969 · S/N 301381 N40090Bank Of Utah Trustee · Salt Lake City, UTS/N 0627E N400MBPrecision Heli-Support LLC · Mesa, AZBuilt 1990 · S/N 0420E N4010RBank Of Utah Trustee · Salt Lake City, UTS/N 0628E N40125N525gm LLC · Bozeman, MTBuilt 2020 · S/N 0625E N4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0589E N405ATRotor Blade LLC · Georgetown, SCBuilt 1980 · S/N 500717D N411AFTeryjon Aviation Inc · Bluefield, VABuilt 1974 · S/N 1040657S N411JHHeidrick Joe · Woodland, CAS/N 0193E N411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620E N415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005E N41776Warbirds-3 LLC · Kalispell, MTBuilt 1967 · S/N 1080820 N41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299D N420KTRegistered aircraftBuilt 2008 · S/N 0582E N420WCWilson Construction Company · Canby, ORS/N 0579E N421KY250 Logistics LLC · Mount Pleasant, TXBuilt 2009 · S/N 0594E N421SPKentucky State Police · Frankfort, KYBuilt 2008 · S/N 0714FF N421VSVertol Systems Company Inc · Destin, FLS/N 1090592D N424WCWilson Construction Co · Canby, ORBuilt 1988 · S/N 0606FF N425WCWilson Construction Co Inc · Canby, ORS/N 0268E N4265JRatcliff Dustin · Saltville, VABuilt 1979 · S/N 790542D N4292DUrocopters Inc · Lancaster, CAS/N 0364E N42FFBeef Aviation LLC · Bradenton, FLBuilt 1984 · S/N 0141E N4337BBatto John H · Carson City, NVS/N 580496 N445SAvitek Inc · Plymouth, MIS/N 230445S N4467VWilson Robert B · Superior, AZS/N 120363S N450AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090202M N451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484D N454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454E N45780Nelson Aviation LLC · Crown Point, INBuilt 1969 · S/N 65-12968 N457GMCentury Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 0603E N458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483D N458PBBarbaro Paul G · Argyle, TXBuilt 1985 · S/N 0123E N46662Brown Helicopter Inc · Pensacola, FLBuilt 1979 · S/N 590510D N469FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 1100854D N46EEUnited States Department Of Agriculture · Cedar City, UTBuilt 1990 · S/N 0406E N47267Mckee John R · Central Point, ORBuilt 1969 · S/N 68-17267

Back to AD 81-26-01 R1