AD 2007-01-06
Registered aircraft · 1,397
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:2007-01-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-01-06')
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:2007-01-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-01-06') 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.
N16760Riggs Bobby W · Lake Mary, FLN16770R & T Aviation LLC · Ethel, LAN16810Southern Helicopter Services Inc · Millington, TNN16832Orgis B J · Hallettsville, TXN168STMotor Heads Inc · Blairstown, NJN16929Reynolds Darryl G · Wills Point, TXN16979Withrotor Aviation Inc · Lakeview, ORN169AAPierce Associates LLC · Prineville, ORN169RLRotorcraft Leasing Co LLC · Broussard, LAN170AMPremier Rotors LLC · Saint Martinville, LAN17238Bennett Aviation LLC · Lafayette, LAN173MSFlorida Keys Mosquito Control District · Marathon, FLN173PStarflite Helicopters LLC · Beaufort, NCN173RLRotorcraft Leasing Co LLC · Broussard, LAN1751Gm Leasing Co LLC · Broussard, LAN17592Premier Rotors LLC · Saint Martinville, LAN175MSFlorida Keys Mosquito Control District · Marathon, FLN176AEAir Evac Ems Inc · Ofallon, MON176PGreenfield Kevin G Trustee · Anchorage, AKN176PDElon Management LLC · Salem, ORN178PAOrlando Aircraft Sales LLC · Orlando, FLN179RLRotorcraft Leasing Co LLC · Broussard, LAN17NRTrans 5 Investments LLC · Saint Martinville, LAN17NXTrans 5 Investments LLC · Saint Martinville, LAN17TLTurbines Ltd · West Point, NEN17TWWhirlybird Aviation LLC · Bend, ORN1807Gm Leasing Co LLC · Broussard, LAN1821Gm Leasing Co LLC · Broussard, LAN182AAIndustrial Helicopters LLC · Lafayette, LAN183DHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN183TCLarson Dylan J · Perham, MNN189RLL&R Investment Partners LLC · Wilmington, DEN1909RCenterline Holdings · Camden, DEN190RHLiberty Blades LLC · Flandreau, SDN191SGAngel William D · Rancho Cucamonga, CAN192AEAir Evac Ems Inc · O Fallon, MON192RLRotorcraft Leasing Co LLC · Broussard, LAN192TAHawkeye Helicopter LLC · Lyndon, KSN193ALBlade Leasing LLC · Homer, AKN194TAJsj Aviation LLC · Helena, MTN1957ZDakota Rotors LLC · Custer, SDN196SJSan Juan Aviation LLC · Wilmington, DEN197AAChem-Air Inc · Shreveport, LAN198HIndustrial Helicopters LLC · Lafayette, LAN198MAMarks Aviation Group LLC · Lafayette, LAFirst renewal noticeN19BHAbc Helicopters Inc · Jefferson, WIN19HXPremier Aircraft Services LLC · Bakersfield, CAN19NGNorgreen Aviation LLC · Kirkland, WAN1AKMeridian Investments LLC · Anchorage, AKN1TNNorman Family Investments LLC · Greenville, TX
Back to AD 2007-01-06