AD 79-06-05
Registered aircraft · 435
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:79-06-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-06-05')
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:79-06-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-06-05') 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.
N176AEAir Evac Ems Inc · Ofallon, MON176ETSan Juan Aviation LLC · Wilmington, DEN179RLRotorcraft Leasing Co LLC · Broussard, LAN17TWWhirlybird Aviation LLC · Bend, ORN1808Gwinnett County Police Dept · Lawrenceville, GAN183PSkytech Cc LLC · Santa Rosa Beach, FLN18FFHeliservice LLC · Wilmington, DEN192RLRotorcraft Leasing Co LLC · Broussard, LAN194TAJsj Aviation LLC · Helena, MTN1957ZDakota Rotors LLC · Custer, SDN19FFHeliservice LLC · Wilmington, DEN19HXPremier Aircraft Services LLC · Bakersfield, CAN2009CMeridian Helicopters LLC · Broussard, LAN201PAAsa Security LLC · Anchorage, AKN202MHSouthern Utah University · Cedar City, UTN202PHCoastal Air Services Inc · Panama City, FLN2036FBell Textron Inc · Fort Worth, TXN203PAD H Helicopter Inc DBA · Mcminnville, ORN205EHSacramento Executive Helicopters Inc · Acampo, CAN205FCGm Leasing Co LLC · Broussard, LAN205GRCentral States Helicopters Inc · Wood River, NEN2064SAgricultural Air Services LLC · Jupiter, FLN2068WChewale Inc · Beaverton, ORN206APInstant Security Services Inc · Wilmington, DEN206DLLauterbach Dennis · Midlothian, TXN206LRHawk Flight · Craig, CON206MPWhirl'D Helicopters Inc · Sevierville, TNN206RFRotors Unlimited LLC · Middletown, DEN206SGClassic Medical Inc · Salt Lake City, UTN206SLAv8-Orr Helicopter Services Inc · Hamilton, MTN206UHPadgett Farms And Forestry LLC · Milan, GAN206UKCrop Flight LLC · Divernon, ILN206WXXtreme Aviation LLC · Falkville, ALN2070UAero-Tech Helicopters LLC · Kingstree, SCN207CPPremier Rotors LLC · Saint Martinville, LAN207MHMeridian Helicopters LLC · Broussard, LAN207RHMorris Equipment LLC · Yuma, AZN20ATFlight Trails Helicopters Inc · Mesa, AZN20SPNew York State Police · Albany, NYN20TVHelicopters Inc · Linden, NJN20ZPatriot Aviation Inc · Greenville, DEN210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN210TVNexstar Media Inc · Irving, TXFirst renewal noticeN2122T22t Aero LLC · Hermosa Beach, CAN212VTLaroche Aviation Services LLC · Bellaire, OHN216LSPremier Rotors LLC · St Martinville, LAN216TVDel Rio Aviation Inc · Paso Robles, CAN21772N21772 LLC · Wellington, FLN220MHPremier Rotors LLC · Saint Martinville, LAN220TSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 79-06-05