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.
N5284FCity Of Houston · Houston, TXN5288XCollier Mosquito Control District · Naples, FLN52RDHelicopter Services West LLC · Benicia, CAN530Valiair Lc Trustee · Casper, WYN530ARN530mx LLC · Missoula, MTN530CGSvp LLC · Tucson, AZN530DGHlh Leasing LLC · Wilmington, DEN530FCFerguson And Sons Construction · Emmett, IDN530FFUtah Aviation Services Inc · Spanish Fork, UTN530FMGooseneck Inc · Heber City, UTN530HBKansas Farm & Ranch Inc · Seneca, KSN530JLLas Vegas Metropolitan Police Department · Las Vegas, NVN530JRApex Heli-Support LLC · Phoenix, AZN530MPRegistration Pending · Missoula, MTRegistration pendingN530RLGulf Helicopters LLC · Santa Fe, TXN530RPGilliam Aviation LLC · Odessa, TXN530STJ&J Holdings And Investments LLC · Phoenix, AZN530TGSummit Helicopter Inc · Pacoima, CAN530THHeliservice LLC · Wilmington, DEN530TTAdvanced Aerospace Consultants Inc · Boynton Beach, FLN530TVTennessee Valley Authority · Muscle Shoals, ALN530VHSvp LLC · Missoula, MTN530WHWinco Inc · Aurora, ORN530XOxford Police Department · Oxford, ALN530XXFerguson And Sons Construction LLC · Emmett, IDN5313YSeley Corp · Ketchikan, AKN531RGS & S Aviation Services Inc · La Crescenta, CAN531VBCity Of Virginia Beach · Virginia Beach, VAN531WCWilson Construction Co · Canby, ORN531WHWinco Inc · Aurora, ORN532LGS & S Aviation Services Inc · La Crescenta, CAN532WCWilson Construction Co · Canby, ORN532WHWinco Inc · Aurora, ORN533DRLt Aviation LLC · Lexington, KYN534WHTwin Equipment LLC · Red Bluff, CAN535WHTwin Equipment LLC · Red Bluff, CAN535WKKit Helicopter Operations LLC · Terreton, IDN535XOxford Police Department · Oxford, ALN536WHWinco Powerline Services · Aurora, ORN537STJ&J Holdings And Investments LLC · Phoenix, AZN537WHWinco Inc · Aurora, ORN53846Aerial Solutions Inc · Tabor City, NCN538STJ&J Holdings And Investments LLC · Phoenix, AZN538WHWinco Inc · Aurora, ORN53HCDrive A Tank Inc · Kasota, MNN53HPHigh Performance Aircraft LLC · El Cajon, CAN540HHBank Of Utah Trustee · Salt Lake City, UTN541Chaparral Air Group · Grapevine, TXN54528Jobe Jeff · Redmond, WAN546Moore Lewis D Jr · Bear Creek, NC
Back to AD 81-26-01 R1