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.

N124PDH & O Helicopters Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0502E N125KWAurora Aviation Services Inc · Delta Junction, AKBuilt 1989 · S/N 0336E N126KWHlh Leasing LLC · Wilmington, DEBuilt 1991 · S/N 0489E N126SRDown East Emergency Medicine Institute · Orono, MES/N 1091299 N12964Sunflower Aero Inc · Atwood, KSS/N 570049 N12THHarding Tim · Bryan, TXS/N 0224E N131ALQuicksilver Air Inc · Fairbanks, AKBuilt 1977 · S/N 1170230D N131NWEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1982 · S/N 1131D N133BHBrown Helicopter Inc · Pensacola, FLBuilt 1969 · S/N 990122S N138SRDown East Emergency Medicine Institute · Orono, MES/N 391106 N138TXAir2 LLC · Blountville, TNBuilt 1979 · S/N 1290646D N13KJCarlston Carl Vaughn · Murray, UTBuilt 1991 · S/N 0444E N13SDSnohomish County Sheriffs Office · Snohomish, WAS/N 380376 N13WDGrayman Group LLC · Coeur D Alene, IDBuilt 1975 · S/N 150685S N142SCSpartanburg County Sheriffs Office · Spartanburg, SCS/N 1180910 N145ALQuicksilver Air Inc · Fairbanks, AKBuilt 1980 · S/N 1200856D N150AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090201M N151JPFarmar Peter D · San Angelo, TXBuilt 1978 · S/N 480301D N155NRState Of Minnesota · Grand Rapids, MNBuilt 2015 · S/N 0623E N1576FCity Of Houston Police Dept · Houston, TXBuilt 2006 · S/N 0802FF N1578FHeliservice LLC · Wilmington, DEBuilt 1981 · S/N 610957D N15THHeliservice LLC · Wilmington, DEBuilt 2003 · S/N 0564E N16002Commonweath Of Massachusetts · East Boston, MAS/N 0194E N1602LSaxton Helicopter Leasing LLC · Plymouth, MIS/N 0225E N1604ZDept Of Fish Wildlife And Parks · Helena, MTBuilt 1989 · S/N 0341E N16050Venturi Aviation LLC · Missoula, MTS/N 0276E N1605KCounty Of Gwinnett Georgia · Lawrenceville, GABuilt 1988 · S/N 0604FF N16062Flight Inspection LLC · Springdale, WABuilt 1989 · S/N 0349E N16069Paragon Air Group · Fort Worth, TXBuilt 1990 · S/N 0433E N160DAWehring Justin DBA · Clute, TXBuilt 1969 · S/N 391115 N160THTerrell Bill · Port Orange, FLS/N 770160D N1610BBlackstead Investments Inc · Boise, IDBuilt 1991 · S/N 0480E N161LAAir2 LLC · Blountville, TNBuilt 1981 · S/N 711015D N163LHeli Fly Inc Trustee · Wilmington, DEBuilt 2019 · S/N 0317FF N165HMidvale Air Research LLC · Lewes, DEBuilt 1985 · S/N 0150E N166MBHelicopter Roundup Service LLC · Nephi, UTBuilt 1980 · S/N 1000831D N167ALFerguson And Sons Construction LLC · Emmett, IDBuilt 1977 · S/N 270083D N16EYCarleton Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0501E N16QRegistration Pending · Fredericksburg, VARegistration pendingS/N 1290227S N17167Slade Aviation LLC · Carlsbad, NMBuilt 1969 · S/N 491127 N173ALFulton Timothy E · Salem, MOBuilt 1976 · S/N 1160020D N174ECBingham Larry F · Juneau, AKBuilt 1969 · S/N 791246 N175JKJk Aviation LLC · Kerman, CABuilt 2000 · S/N 0143FF N175JLRatcliff Dustin · Saltville, VABuilt 1977 · S/N 270076D N17801Mckee John R · Central Point, ORBuilt 1968 · S/N 380352 N1808Gwinnett County Police Dept · Lawrenceville, GABuilt 2019 · S/N 0318FF N187YMBrown Byron Tim · Hermiston, ORS/N 691183 N18CPPeoples Properties LLC · Tucson, AZBuilt 1990 · S/N 383E N18FFHeliservice LLC · Wilmington, DEBuilt 2006 · S/N 0146FF N191VSVertol Systems Co Inc · Destin, FLS/N 800-766D

Back to AD 81-26-01 R1