AD 2002-13-05
Registered aircraft · 484
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:2002-13-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:2002-13-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:2002-13-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:2002-13-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.
N369TAHva Inc · Summersville, WVN369TRChehalem Helicopters LLC · Newberg, ORN369TVTennessee Valley Authority · Muscle Shoals, ALN369WYReece Construction Company · Marysville, WAN36FGCalifornia Department Of Fish & Wildlife · Sacramento, CAN36KRDragonfly Aviation LLC · Mirando City, TXN371PDCity Of Atlanta · Atlanta, GAN377LWPremier Helicopters LLC · Kalispell, MTN383FJ&J Holdings And Investments LLC · Phoenix, AZN40090Bank Of Utah Trustee · Salt Lake City, UTN400MBPrecision Heli-Support LLC · Mesa, AZN4010RBank Of Utah Trustee · Salt Lake City, UTN40125N525gm LLC · Bozeman, MTN4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN405ATRotor Blade LLC · Georgetown, SCN411JHHeidrick Joe · Woodland, CAN411WJNorthwest 60 LLC · Kalispell, MTN415WCWilson Construction Co · Canby, ORN41AJEnglish Air Service LLC · Georgetown, TXN420KTRegistered aircraftN420WCWilson Construction Company · Canby, ORN421KY250 Logistics LLC · Mount Pleasant, TXN421SPKentucky State Police · Frankfort, KYN421VSVertol Systems Company Inc · Destin, FLN424WCWilson Construction Co · Canby, ORN425WCWilson Construction Co Inc · Canby, ORN4265JRatcliff Dustin · Saltville, VAN4292DUrocopters Inc · Lancaster, CAN42FFBeef Aviation LLC · Bradenton, FLN43BATerrell Bill · Port Orange, FLN451HAIron Horse Aviation LLC · Marshalltown, IAN454JHJack Harter Helicopters Inc · Lihue, HIN457GMCentury Aviation Inc Trustee · Wilmington, DEN458HWHeliwild Investments LLC · Austin, TXN458PBBarbaro Paul G · Argyle, TXN46662Brown Helicopter Inc · Pensacola, FLN469FCFerguson And Sons Construction LLC · Emmett, IDN46EEUnited States Department Of Agriculture · Cedar City, UTN473EOchoco Wood Products LLC · Prineville, ORN484Bhh Leasing #2 LLC · Pensacola, FLN48MPPope James D · Lewiston, IDN499SLHlh Leasing LLC · Wilmington, DEN49WKRail N LLC · Oracle, AZN4RRBlue Sky Air Services LLC · Wilmington, DEN500ARHelicopter Roundup Service LLC · Nephi, UTN500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKN500DCHva Holdings LLC · Gettysburg, PAN500EKKar Aviation LLC · Saltville, VAN500EVSnohomish County Sheriff · Snohomish, WAN500FCFerguson And Sons Construction LLC · Emmett, ID
Back to AD 2002-13-05