AD 81-26-01 R1
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
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.
N9010FCody Richard A · Mclean, VAN9016FHigh Shines Inc · Earl Park, INN9020FSideline Services LLC · Pearland, TXN9034FStuart Aviation Inc · Wilmington, DEN9052FMotivated Air LLC · Felton, DEN907BHBering Air Inc · Nome, AKN90ALCherry Helicopters Inc · La Jolla, CAN9107FUp Rite Aviation LLC · Zeeland, MIN9113QSea Corp Helicopters Inc · Wilmington, DEN9117HBrown Helicopter Inc · Pensacola, FLN9118FCook Jeffrey G Trustee · Ventura, CAN911BYAmerican Honor Foundation Inc · Melourne, FLN911CPSt Louis County Police Department · Clayton, MON911HKCounty Of Kauai-Fire Department · Lihue, HIN911HUUsda Aphis Ws Atoc · Cedar City, UTN911HYHawaii County Fire Department · Hilo, HIN911JXSt Louis County Police · Chesterfield, MON911MUSt Louis County Police Dept · Clayton, MON911NYSt Louis County (Mo) Police Dept · Chesterfield, MON911PHSt Louis County Police Department · Clayton, MON911VBCity Of Virginia Beach · Virginia Beach, VAN911WYLas Vegas Metropolitan Police Department · North Las Vegas, NVN9132FHorizon Aviation LLC · Glastonbury, CTN9146FBerling Robert E · Mooresville, INN9159FApex Heli-Support LLC · Phoenix, AZN915LYLyons Aircraft Leasing LLC · Hillsboro, ORN9166FNorthstar Marine LLC · Lewes, DEN9176F76f LLC · Calhoun, GAN9177FRotor View Inc · Wilmington, DEN9196FAsbill Jimmy T · Winnsboro, TXN9204UAnduril Industries · Costa Mesa, CAN920FCFresno County Sheriff Dept · Fresno, CAN920JPKar Aviation LLC · Saltville, VAN921SDCounty Of Fresno · Fresno, CAN922SDCounty Of Fresno · Fresno, CAN9233FC & D Helicopters LLC · Spanish Fork, UTN9260FRjo LLC · Kenansville, FLN9267FManulwa Airways Inc · Hilo, HIN926DDTurbine Flying Penguins LLC · Gardnerville, NVN926ESRoyal Helicopter Services LLC · Exeter, CAN9276FHeli-Flite Inc · Corona, CAN935MAlan Aviation LLC · Los Angeles, CAN93MDNew Horizons Helicopters Inc Trustee · Wilmington, DEN9413FHelicopter Minit Men Inc · Columbus, OHN9460TEvermore Aviation LLC · Wasilla, AKN951CPCity Of Cleveland · Cleveland, OHN952CPCity Of Cleveland · Cleveland, OHN952SFRegistration Pending · Elko, NVRegistration pendingN9677NDat Aircraft LLC · Lewes, DEN969MSWhirlwide Inc · Fresno, CA
Back to AD 81-26-01 R1